We have a requirement of downloading all the orders by inputting from and to dates, in excel or CSV format using APIs. I had used orders API, but somehow the data is not right. The desired output can be compared to excelify option on the platform, downloaded manually.
Could you please help me in identifying the right API, and the steps thereafter, to download the past orders data. TIA.
Renars here from Matrixify (Excelify).
I understand that you wish to build your own app or private app for this.
But you sure can also just use Matrixify (Excelify) for manual and automated Order data exports. You can also apply filters when creating an export in the app by clicking the "Filters" button under Orders.
There you can filter Orders export by Created At, Updated At, and Processed At dates among other filters. We even have a Relative Date condition for date filters for automated exports.
Regarding the API used - currently Matrixify (Excelify) uses the REST Orders API for Order data export, and combines it with Products API in some cases to get more Line Item details.
But given that there are years of development and workarounds behind it (as no API is perfect), then I would suggest looking into using the app and what already is there instead of making everything from 0.
If Matrixify (Excelify) is lacking some features that you would need, then please let me know so we can properly document them for future development.