Zapier and Zoho Analytics API
I'm having a problem setting up a Zap using the Zoho API. I'm currently using the Zoho analyticz API to get data and write data into tables using Power Automate Desktop but for a certain task i need to connect it to Zapier to get the last row from a table and send it by email. Using the same logic and credential i've been using in PAD gives me a an
error which I'll post below. As far as i remember the scope set up in console was for all so it should be ok for a simple GET to read a row. Any idea what i'm doing wrong?
error which I'll post below. As far as i remember the scope set up in console was for all so it should be ok for a simple GET to read a row. Any idea what i'm doing wrong?
The logic for zap is - POST In Webhooks to get the Token using my credentials and then using the Token in API Request (Beta) to get the last row of data.
The url is https://analyticsapi.zoho.com/restapi/v2/workspaces/xxxxxx/views/xxxxxx/data?CONFIG=%7B%22columns%22%3A%5B%22Saptamana%22%2C%22Incasari%22%2C%22Incasari%20Total%22%2C%22Teste%20Battlecards%22%2C%22Teste%20FastEmail%22%2C%22Teste%20Modul%20Materiale%22%2C%22Teste%20Director%20Firme%22%2C%22Oferte%20V%22%2C%22Oferte%20Ah%22%2C%22Oferte%20PS%22%2C%22Oferte%20TOP%22%2C%22Oferte%20SO%22%2C%22Clienti%20pierduti%22%2C%22Reabonari%22%2C%22Rata%20de%20succes%22%2C%22Leaduri%20V%22%2C%22Leaduri%20C%22%2C%22Utilizatori%20cu%20peste%2015%20logari%22%2C%22Utilizatori%20cu%20cel%20putin%201%20logare%22%2C%22Utilizatori%20fara%20logari%22%2C%22Companii%20cu%20toti%20utilizatorii%20fara%20logari%22%2C%22Procent%20utilizatori%20fara%20logari%22%2C%22Procent%20companii%20cu%20toti%20utilizatorii%20fara%20logari%22%2C%22Proiecte%20noi%22%2C%22Proiecte%20updated%22%2C%22Verified%20Data%22%2C%22Desktop%20Data%22%2C%22Proiecte%20private%20noi%22%2C%22Licitatii%22%2C%22Atribuiri%22%2C%22Proiecte%20cu%20poze%22%2C%22Reclamatii%22%2C%22Actualizari%22%2C%22PDSuri%22%5D%7D
Response Body
{"status":"failure","summary":"INVALID_OAUTHSCOPE","data":{"errorCode":8540,"errorMessage":"This API request cannot be processed using the provided token. Kindly make sure that the token was created using the required scope."}}