Volusion Integration : API
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=Generic\Customers&SELECT_Columns=CustomerID,BillingAddress1,City,CompanyName&WHERE_Column=CompanyName&WHERE_Value=WDCi