Todos os Endpoints
offline
Cole o JSON retornado pela query. Se houver múltiplos dispositivos, escolha qual usar.
SELECT
ca."name" AS nome,
ca.identifier AS numero,
ca.id AS channel_id,
json_build_object(
'token', aa.access_token,
'waba', aa.external_id,
'phone', ca.external_id,
'biz', ca.meta::json->>'business_id'
) AS credenciais
FROM app_authentication aa
JOIN channel_account ca ON ca.app_authentication_id = aa.id
WHERE aa.owner_id = 'UUID_DO_CLIENTE'
AND (ca.status = 'CONNECTED' OR ca.deleted = false)
Execute essa query no banco do cliente para obter os IDs e token necessários.
SELECT
ca."name" AS nome,
ca.identifier AS numero,
ca.id AS channel_id,
json_build_object(
'token', aa.access_token,
'waba', aa.external_id,
'phone', ca.external_id,
'biz', ca.meta::json->>'business_id'
) AS credenciais
FROM app_authentication aa
JOIN channel_account ca ON ca.app_authentication_id = aa.id
WHERE aa.owner_id = 'UUID_DO_CLIENTE'
AND (ca.status = 'CONNECTED' OR ca.deleted = false)
SELECT
ca."name" AS Nome_Dispositivo,
ca.identifier AS Number_Phone,
ca.id AS Channel_account_id,
aa.external_id AS WABA_ID,
ca.external_id AS PHONE_NUMBER_ID,
ca.meta::json->>'business_id' AS business_id,
aa.access_token AS token
FROM app_authentication aa
JOIN channel_account ca ON ca.app_authentication_id = aa.id
WHERE aa.owner_id = 'UUID_DO_CLIENTE'
AND (ca.status = 'CONNECTED' OR ca.deleted = false)
Copie o valor da coluna dispositivos e clique em Auto na sidebar para preencher todos os campos de uma vez. Suporta múltiplos dispositivos.