How can we help?

New post
0

Zoho Query API

Avatar
Maxitech Maxitech
None
Follow

Hi,

I am trying to write select queries to retrieve data from Zoho using its Query API. But I am getting the following error:

Service responded with exception status (401): {"code":"OAUTH_SCOPE_MISMATCH","details":{},"message":"invalid oauth scope to access this URL","status":"error"}

I searched this but couldn't understand what I am doing wrong.

Can anybody help with this configuration? 

I attached my connection configurations (it still gets the same error with or without the "scope" parameters):

Date Votes

3 comments

  • 0
    Avatar
    Meggan King

    Hello,

    Thanks for posting the details here. Zoho is a service which uses an OAuth token to authenticate. Each OAuth token has specific scopes which tell it which data it can fetch from the service. You can review the scopes by looking at each token in your account here

    https://app.klipfolio.com/credentials/index

     

    For example, the only scope we support with Zoho is

    So your query is failing because it trying to use a scope we don't support. 

     

    Sometimes we can have new scopes added to the a service, but this takes time and requires development work to be scheduled. Do you need to access data for ZohoCRM.coql.READ? 

     

    Thanks

    Meggan

  • 0
    Avatar
    Maxitech Maxitech

    Hi Meggan,

    Thanks for the reply.

    I need to visualize our Zoho modules data. For example, we want to see how many of which records waiting in a specific step in Zoho. In order to achieve this calculation, I thought I should use the Query API of Zoho. Because with the Zoho Rest API, I can only retrieve the records list but it gives me a limited list (200 records only but have more than that) that I can do calculations with. If you can suggest any other best practices or examples visualizing data on Zoho as in my use-case, I would definitely appreciate it but otherwise, I think we need ZohoCRM.coql.READ to use Query API.

    Thanks

  • 0
    Avatar
    Meggan King

    Hi 

    You may just need to paginate the query with the Zoho Rest API scope we currently support. We have a few ways to paginate data via an API, based on the connector type. Some services paginate by using a page number at the end of the query and some paginate using a limit and offset value.

    I'd recommend reaching out to the support team to get help, but these documents should also be useful.

    https://support.klipfolio.com/hc/en-us/articles/218946328-Data-sources-with-multiple-pages-

    https://support.klipfolio.com/hc/en-us/articles/216182487-MAPFLAT-and-MAP

     

    Thanks

    Meggan

Please sign in to leave a comment.