Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Iterative Macro for API Pagination -

suarezr
7 - Meteor

The last post was super helpful, so I thought I would try another.

 

I am having trouble finding articles about passing filters to the API query, as that filtering requires passing multiple parameters with their own values and the Payload tab seems to not have a grouping function.

I am trying to filter for the last 30 days of data, what is the best practice for configuring the filtering in the Payload tab?

For reference, if I was just passing through JSON I think this is the correct configuration:{
"filterGroups": [
{

"filters": [ {
"propertyName": "lastmodifieddate",
"operator": "GTE",
"value": 30_days_ago
} ] } ] ,
"properties": ["name", "lastmodifieddate"],
"limit": 10,
"sorts": [ {
"propertyName": "lastmodifieddate",
"direction": "DESCENDING"
} ] }

2 REPLIES 2
abacon
13 - Pulsar

@suarezr Without knowing the API you are querying, it is hard to say what are best practices.

 

Here is how I would approach it - Get the documentation for the specific API I am querying>build it out in Postman to the desired state using the documentation as a guide>move to Alteryx with the API call.

 

Bacon

apathetichell
20 - Arcturus

@suarezr following up on @abacon 's sagely advice --- each row is a call to an API. the Download tool does not perform any aggregations or payload building. The payload MUST be a single column which is preformatted which you send in. You can use summarize/formula to get this to look the way you want.

Labels
Top Solution Authors