How do you write http_response to excel

Hi @Kudlappa_Gouder,

I’m trying to write http_response to excel. Can you please guide me on this?

1 Like

@vallepukalyan562 Whatever response you are getting in http response will be in JSON format.
You need to convert the data in below format in order to write it to excel.

“My List”: [
“Country”: “Russia”,
“Capital”: “Moscow”
“Country”: “USA”,
“Capital”: “Washington DC”

(My List - Sheet name.
Country - Column Header1
Capital - Column Header2
Russia and Mosow - Row1
USA and Washington DC - Row2)

You can also refer this document for more details.
Write Excel file – ElectroNeek Help Center

1 Like

Hi @Kudlappa_Gouder ,
Thanks for response , working fine.

1 Like