How to map columns and rows of a json file to get the values from a smartsheet API request
I'm new to work on the Smartsheet integration using API.
I have a request to load the data from the Smartsheet to a database table using Azure Data Factory. Through Smartsheet API connection I could able to read the data in a json format. To load it a database table I have to map the columns and rows so that I can able to get it in a table format. When I went through the json file, columns are maintained in a separate array and rows are maintained in a separate array. Can I know how to map columns and rows of a json file to get the values? An example to map the columns and rows would be better to understand.