web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to get data from "...
Power Automate
Unanswered

How to get data from "odata.nextLink": "https://xxxx

(0) ShareShare
ReportReport
Posted on by 31

Could anyone suggest how to get data from "odata.nextLink": "https://xxxx after receiving json resutl from Send an HTTP request to SharePoint?

 

Is it possible to parse it as json and use it in another HTTP request to SharePoint?

I don't know where should I put odata.nextLink to. It should be SiteAddress or URI? I tried both and still fail.

 

Thanks!odata.png

Categories:
I have the same question (0)
  • Verified answer
    Michael E. Gernaey Profile Picture
    53,335 Super User 2025 Season 2 on at

    Hi @Maijija117 

     

    You are spot on actually nice deduction. In this instance I cannot remember though if its a Header that came back or in the Body.

     

    But if its in the Body, then yes

    Do this

    1. Run the process one time where you call SharePoint the first time, after that we dont care if it fails

    2. Go to the Details page, go to the history of runs, and open the one you just did

    3. Copy the Output from the call

    4. Add a  Parse JSON action

    for the Schema click the button as a sample, paste in what you copied

    5. For the input, use the Output (might be called body) from the HTTP Request, from the Dynamic Content Window

     

    As long as we copy and paste the right schema and or make sure we pick the right output and level of json path, you will be able to get the odata.nextlink

     

    If you share the flow details with the run I can help more, but you are 150% on the correct path.

     

    P.S. technically you dont need a Parse JSON its just a teaching/learning opportunity. You could use a Compose, click on the Dynamic Content, which will add something like body(...) or output(...) and when you hover over it you will see the total "path" it creates.

     

    If you take that.. and you visually look at the output, you can figure out the path to the odatalink

    Imagine the out put looks like this

    body('HTTP_REQUEST')['body/value']
    

    And when you look at the Response JSON, you can clearly see the value Object. Thats your start path

    And if the odatalink is simply a child then you would have

    body('HTTP_REQUEST')['body/value']?['odata.nextlink']

     

    Just an example but another way.

     


    Cheers
    If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

  • Maijija117 Profile Picture
    31 on at

    I used this compose and it worked.

    I cannot use odata.nextlink straight foward but It must cut something off then put it to URI for connector Send HTTP.

     

    slice(body('Parse_JSON')?['odata.nextLink'], nthIndexOf(body('Parse_JSON')?['odata.nextLink'], '_', 4))

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard