JSON behind URL to Excel

New Altair Community Member

Nov 21, 2019

Updated Nov 5, 2024 by Jocelyn

Dear Rapidminer Community

I have about 55 URLs each containing JSON data. How can I crawl the JSON data behind the URLs and combine/convert them to one .xlsx file?

Here are three URLs as a sample:

https://link.retailflux.com/flow/api/v2/json/FFE3234CDFF3919C5BBAFEAA63AA13E3/query/?store_alias=ochsnermultergasse&start_date=2019-10-07T08:00:00&end_date=2019-10-12T23:00:00&period=hourly

https://link.retailflux.com/flow/api/v2/json/FFE3234CDFF3919C5BBAFEAA63AA13E3/query/?store_alias=ochsnermultergasse&start_date=2019-10-14T08:00:00&end_date=2019-10-19T23:00:00&period=hourly

https://link.retailflux.com/flow/api/v2/json/FFE3234CDFF3919C5BBAFEAA63AA13E3/query/?store_alias=ochsnermultergasse&start_date=2019-10-21T08:00:00&end_date=2019-10-26T23:00:00&period=hourly

Thank you for your support

Best regards
GL

Find more posts tagged with

🎉Community Raffle - Win $25

JSON behind URL to Excel

Find more posts tagged with

Quick Links