Volusion has an interesting API. It allows you to somehow perform a “SQL query” in the URL. For example, if I want to query customer with the following SQL:
SELECT CustomerID,BillingAddress1,City,CompanyName FROM Customer WHERE CompanyName=’WDCi’
I can achieve it with the following URL:
https://<volusion_url>/net/WebService.aspx?Login=<login>&EncryptedPassword=<encrypted_password>&EDI_Name=GenericCustomers&SELECT_Columns=CustomerID,BillingAddress1,City,CompanyName&WHERE_Column=CompanyName&WHERE_Value=WDCi
Referd BY:https://blog.wdcigroup.net/2011/04/volusion-integration-api/
