Now that it's live, don't forget to accept your certification badge on Credly today! Learn more here.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

String Limit

Dennisklad1
8 - Asteroid

Hi,

 

I have a small workflow that gets data from a GET API Call and parses the ouput with the JSON Parse tool. It seems like the API does not return all data and something wierd is happening in the workflow.

 

The returned string is pretty large and cannot be displayed with a browse tool and i was wondering what i can do inorder to see why there are only 300 rows shown.

3 REPLIES 3
shreyanshrathod
11 - Bolide

Hi @Dennisklad1 ,

 

Almost all API's that I have worked with return a specified number of rows per GET request.

E.g Google Gmail API outputs 100 records per GET API request.

 

There is always a PAGE TOKEN parameter associated with your API query.

Page Token helps you to iterate over your API requests to get all the records.

 

Please read in detail about the API you are requesting to.

 

Regards,

Shreyansh Rathod

Dennisklad1
8 - Asteroid

Thanks for the reply. I didnt know that.

I am accessing data from our sharepoint site with the endpoint "tenant/_api/ProjectData/Tasks". Do you mean to add the page parameter say in the body of the request?

shreyanshrathod
11 - Bolide

Yes, there might be a page parameter.

The Custodian of your API will know better.

 

Although, this is just my guess. Your API person can help you more on the same.

 

 

Labels