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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Power Automate Cloud h...
Power Automate
Unanswered

Power Automate Cloud http request only returns first result in JSON

(0) ShareShare
ReportReport
Posted on by 11

Hey all,

 

An http request I'm making with Power Automate cloud only returns the first result in JSON, but returns the full JSON results on both PA desktop, Postman, and I even get the full results in CSV on PAC. Any thoughts to why this is happening? Thanks

 

inputs:

 output:

{
"inputs": {
"method": "GET",
"uri": "https://api.webscraper.io/api/v1/scraping-job/918748/csv?api_token=@{variables('WebScraperAPIKey')}",
"headers": {
"Accept": "application/json",
"Content-type": "application/json"
}
},
"runtimeConfiguration": {
"contentTransfer": {
"transferMode": "Chunked"
}
},
"metadata": {
"operationMetadataId": "1096a8f8-5650-4c6a-b99e-ecabdef82564"
}
}

 

 

Output:

There should be 250ish results in the body and you can see the by the Content-Length that information is there but not showing up.

{
"statusCode": 200,
"headers": {
"Transfer-Encoding": "chunked",
"Connection": "keep-alive",
"Vary": "Accept-Encoding",
"Pragma": "public",
"X-RateLimit-Limit": "200",
"X-RateLimit-Remaining": "196",
"X-Frame-Options": "DENY",
"Strict-Transport-Security": "max-age=47474747; includeSubDomains; preload",
"Cache-Control": "must-revalidate, private, post-check=0, pre-check=0",
"Date": "Mon, 24 Apr 2023 13:55:02 GMT",
"Server": "nginx/1.18.0,(Ubuntu)",
"Content-Disposition": "attachment; filename=Competitor_scrape.json",
"Content-Type": "application/json",
"Expires": "0",
"Content-Length": "62826"
},
"body": {
"web-scraper-order": "1682343731-1",
"web-scraper-start-url": "competitor url",
"sku": "product id",
"description": "product description",
"image-src": "product image url",
"price": "$244.00"
}
}

Categories:
I have the same question (0)
  • Expiscornovus Profile Picture
    33,501 Most Valuable Professional on at

    Hi @MattPowerhouse,

     

    Looking at the input I see you might have configured chunking in the settings of the HTTP action, is that correct?

    https://learn.microsoft.com/en-gb/azure/logic-apps/logic-apps-handle-large-messages#download-content-in-chunks

     

    Are you using that setting for a specific reason? Alternatively, have you tried running the same request while disabling that setting?

     

    allowchunking.png

  • CU07011812-0 Profile Picture
    11 on at

    Hey, 

     

    I've tried it with and without and had the same results. I think I had turned it on just to see if it changed anything. In desktop it works with or without. The issue seems to be exclusively on the cloud version.

  • Expiscornovus Profile Picture
    33,501 Most Valuable Professional on at

    Hi @MattPowerhouse,

     

    I am not familiar with this API. However, I do see in the docs that there is also a json output option. Have you tried that one to see if it returns all the results? Just for comparison/troubleshooting purposes.

    https://api.webscraper.io/api/v1/scraping-job/<SCRAPING JOB ID>/json?api_token=<YOUR API TOKEN>

     

    And how many pages does that job have?

    https://api.webscraper.io/api/v1/scraping-jobs?api_token=<YOUR API TOKEN>

     

  • CU07011812-0 Profile Picture
    11 on at

    Hey @Expiscornovus 

     

    The JSON output is the one I'm using with the issue. I must have accidently pasted the CSV one in my first post. Thanks.

  • Expiscornovus Profile Picture
    33,501 Most Valuable Professional on at

    Hi @MattPowerhouse,

     

    In that case my question is: Do you see different/more results with the CSV output format? 😁

  • CU07011812-0 Profile Picture
    11 on at

    Hi @Expiscornovus 

    Yes, that's the odd part. See opening post "but returns the full JSON results on both PA desktop, Postman, and I even get the full results in CSV on PAC. Any thoughts to why this is happening?"

     

    JSON output on cloud is the only instance where I'm NOT getting all the results, and of course it's the one I want to work. lol

     

    Thanks again.

  • Expiscornovus Profile Picture
    33,501 Most Valuable Professional on at

    Hi @MattPowerhouse,

     

    Sorry, I misread that part in your opening post, my bad 😅

     

    Yeah that is strange. Like I mentioned in one of previous replies. Only thing which I can imagine is that their is some paging/pagination going on. However, you have checked that it is job with a single page of results, correct?

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 112 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 52

#3
Ellis Karim Profile Picture

Ellis Karim 51 Super User 2026 Season 1

Last 30 days Overall leaderboard