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