Hello, I call an API every 4 hours that returns me an update of some data by project. I need to put the new values bellow the existing ones in an Excel file (append). Here is an example of the API output: example-json-data.json (517 Octets) ▶ example-json-data I use StudioX 2023.10.7 I get my d…

Problem converting JSON Array to DataTable to then append in an Excel file

alex87 (Alex) September 27, 2024, 7:33am 4

Directly from the JSON Array I got from the API I was able in Studio to put it in a DataTable and then in Excel without issues:
JSON Array to DataTable

Topic		Replies	Views
Data Table to JSON (Array) Activities excel , activities	6	3214	October 25, 2020
Convert response body into excel Studio excel , uiautomation , api , rest-api , web-api	7	1018	February 25, 2023
JsonArray to Datatable Studio	23	13535	May 12, 2023
Excel to JSON Conversion Help excel , activities , question , json	13	5878	January 15, 2021
How to add an array data into datatable Studio studio , question , activities_panel	18	5063	May 31, 2022

Problem converting JSON Array to DataTable to then append in an Excel file

Related topics