Iterative Macro for API Pagination -

[suarezr]

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"
} ] }

[abacon · Accepted solution]

@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]

@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.