We are trying to set up an API connection between CData and Shopify. We are wanting to pull order information into CData so that we can process the information into our ODBC connection.
We are able to establish a connection and pull data into a spreadsheet. However, we are only able to populate header fields. The actual data underneath those headers is showing as empty.
How do we fix the data not being populated? Our store has been running for a while and has plenty of orders. But the order data is not populating.
Any suggestions are greatly appreciated.