![]() I am only trying to get the "ac_monthly" array.and will then be inserting those 12 values into individual cells in my sheet. This will return XML (or with a slight modification, JSON) data formatted as described here: Once I get the data into my workbook, I can take it from there.I just need help getting data from a precomposed URL string. It is also OK if I need to set up each parameter as a reference to a cell rather than the URL string being precomposed. My URL can be formatted to return XML or JSON data if one format or the other gives me the capabilities I am looking for. I am certain there must be a way to do this.but I have not been able to find it. I have formatted the URL properly and have it in a cell that is named ApiUrl however when I try to set up a data source in Excel, it seems to always require me to provide the URL in the setup wizard rather than referencing data in my spreadsheet (such as this pre-formatted URL). Here is an example of JSON file with multiple levels of nested data. Importing data from JSON files (or Web APIs) can be challenging for end users. Automatic table detection from JSON files. ![]() I have an API call to make from my Excel spreadsheet that will have various parameters depending on the data entered in the spreadsheet. To load a JSON file from the web, select the Web connector, enter the web address of the file, and follow any credential prompts. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |