Skip to main content
medc0001
New Participant
Feb 11, 2021 3:11 PM UTC
Question

@odata.nextLink

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

    4 replies

    medc0001Author
    New Participant
    Feb 12, 2021 1:49 PM UTC

    I realized that the solution is in using the process modeler. Below is how I am accomplishing this. Americo

    alexl0007
    Inspiring
    Feb 18, 2021 6:12 PM UTC

    [mention:485511b024df48cdbd7ca405aaa571d9:e9ed411860ed4f2ba0265705b8793d05] 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?

    medc0001Author
    New Participant
    Feb 18, 2021 6:30 PM UTC

    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'

      Terms & ConditionsAccessibility statement