Is there a way to programmatically reset exported orders in the Volusion API?
I have a small python script that repeatedly requests the Volusion API to fetch columns from an Orders table.
I am submitting my HTTP request repeatedly because Volusion only returns the first 200 records each time. I post until I get an empty XML response saying I have all the entries.
Now, to run the same query again, I have to manually log into Volusion and "reset" to "Volusion API: Run Generic \ Orders". Do you know how to reset this via API?
source to share
To clarify this a bit ... I think the volusity actually only returns 100 records at a time. Each call to their api gives you the next 100 records, which makes the previous 100 records unavailable. Eventually you will get to the end of the recordset and the api will return nothing. To start fetching the results again from the api call that is generated and saved under Product / Import-export / api, you need to manually log in and reset the export. NOTE. Resetting does not actually delete the entries. This made me cringe the first time I reset my api.
To answer your question, I contacted Volusion about this and said no. I'm not sure I've ever spoken to someone who knows. It seemed like everyone was at the bottom of tech support. But if new entries are added through more sales through the Volusion store front, they will be returned the next time your code makes an api call. Soooo, while not perfect, it works for initial imports.
Workaround: You can make conditional api calls (for example, where orderID = 2344, 2345, etc.) all day long. Thus, import your orderID into your local database using them to loop through and create your conditional api calls. It's slow. I created a job that runs overnight and updates my local database with some information about returned parts and other order changes.
Be warned : Volusion regularly brings up its site overnight for maintenance (to be expected). Their API integration is slow (to be expected as well). It doesn't make all the data available through manual export available through API calls (for example, the amount returned.) I think this is serious. The non-return sales figures are, in my opinion, incomplete. I would say that the Volusion API Integration does not contain substantial documentation and does retell its advertisement for the API integration.
They have partners who can make calls to data not publicly available through the api. I don't know the exact details. I'm not sure if Volusion is creating custom schemas for partners or if they figured out the url. I would really like some information on how to get the returned item count via the Volusion api.
source to share