Async function main(workbook: ExcelScript.Workbook) { let iRows = 0; let aTemp=[]=[]; const myHeaders = new Headers({'app-id': '############'}); const myInit = { method: 'GET', headers: myHeaders }; let fetchResult = await fetch('https://dummyapi.io/data/v1/user?limit=10',myInit); let oData: dataType = await fetchResult.json(); let json: JSONData[] = oData.data; ... - Source: dev.to / over 1 year ago

Note: I converted JSON data obtained from DummyAPI to Google sheets using this tutorial. (I know I could have directly imported data using the NoCodeAPI import feature but since the data was nested and not working without the Dummy API header, so I had to go through this and then import the .xlsx file to google sheets manually xD. You learn something new every day.). - Source: dev.to / over 2 years ago

Working in PowerShell (.Net regex) one of my favorite tools is https://ultrapico.com/expresso.htm. It does require registering for a free license but it's well worth it. Source: about 2 years ago

Then you need this or something like it: https://ultrapico.com/expresso.htm. Source: over 2 years ago