web
You’re offline. This is a read only version of the page.
close
Skip to main content
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,181 Most Valuable Professional on at
    Re: Power Automate Cloud http request only returns first result in JSON

    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
    Re: Power Automate Cloud http request only returns first result in JSON

    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,181 Most Valuable Professional on at
    Re: Power Automate Cloud http request only returns first result in JSON

    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
    Re: Power Automate Cloud http request only returns first result in JSON

    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,181 Most Valuable Professional on at
    Re: Power Automate Cloud http request only returns first result in JSON

    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
    Re: Power Automate Cloud http request only returns first result in JSON

    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,181 Most Valuable Professional on at
    Re: Power Automate Cloud http request only returns first result in JSON

    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

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 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard