I built an integration using Microsoft Graph so I'm limited in retrieving 100 records per request. I know I need use the @odata.nextLink in the next GET call. In Power Automate I just loop through the calls using the @odata.nextLink and append each set of results in a array variable. How do I do this in Appian?
Thank you,
Americo
Discussion posts and replies are publicly visible
I realized that the solution is in using the process modeler. Below is how I am accomplishing this. Americo
medc0001 how did you access the @odata.nextLink from the JSON? I tried a!fromJSON(objHere("/users")).result.body).@odata.nextLink but returns null. In your process, how did you scrape that value?
Below is the format of the output response from the integration rule!MC_SP_GetPresbyterateSharepointList which is call to a sharepoint list. The Odata link is in the body section of output.
Then built expression rule with the uri as rule input. Since odata prefixed with @ sign need to enclose with ' '
rule!MC_SP_GetPresbyterateSharepointList(ri!uri).result.body.'@odata.nextLink'
Yes, that final picture was the answer medc0001, thank you so much for sharing that with me. Nowhere in the documentation that I've seen that shows this to access to other properties.