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