I have a PHP application which connects to a Volusion store and exports customers details using query string. But I can't select the LastLogin field from customers table, it does not show in the XML data. My query string is as follows:
$url="http://www.domain.com/net/WebService.aspx? Login=jusername&EncryptedPassword=7602B3272D929D17B5138382F2AE4F4C6102A12AEB1F476293C16A5F731949B6&EDI_Name=Generic\Customers&SELECT_Columns=CustomerID,LastLogin";
When I run the query I get results with fields CustomerID and EmailAddress instead of CustomerID and lastLogin. Why?
You can only retrieve the LastLogin data for specific customer ID using this method through the Volusion API.
If you want to retrieve all of the LastLogin data for all customers at the same time you will have to run a saved SQL query via the API. This SQL query would be stored in your generic folder along with the required XSD file.
You would then run it like a API call but instead call the file.
The text in the SQL file would be something like
SELECT Customers.CustomerID, Customers.LastLogin FROM Customers WITH (NOLOCK) ORDER BY Customers.CustomerID
Assuming file name is lastlogin.sql, you would call it like so but without the sql extension.
...&EDI_Name=Generic\lastlogin
EDIT:
For specific customer you would use the following.
...&EDI_Name=Generic\Customers&SELECT_Columns=CustomerID,LastLogin&WHERE_Column=CustomerID&WHERE_Value=146
