SWS2 GetDataView Method – quote_reconciliation_v
This view, quote_reconciliation_v, pulls quotes created and includes information on when and who create the quote.
Returned Parameters
Name | Data Type |
---|---|
QUOTE_ID | Long |
Description | The quote’s ID number. |
ORG_ID | Long |
Description | The organization’s ID number. |
CREATED_BY | Long |
Description | The user’s ID that originally created the quote/reservation. |
USER_NAME | String |
Description | The username of the person that originally created the quote/reservation. |
QUOTE_TYPE | Integer |
Description | The numeric value for the type of quote/reservation. |
QUOTE_TYPE_VAL | String |
Description | The textual value for the type of quote/reservation. |
STATUS | Integer |
Description | The numeric value for the status of the quote/reservation. |
QUOTE_STATUS_VAL | String |
Description | The textual value for the status of the quote/reservation. |
QUOTE_SOURCE | String |
Description | The application through which the quote/reservation was created. |
QUOTE_START_DATE | DateTime |
Description | The date the quote/reservation was originally created. |
EXPIRATION | DateTime |
Description | The date the quote/reservation is no longer available to the customer. |
SITE_ID | Long |
Description | The site’s ID number. This can be found using the GetSiteList method. |
SITE_NAME | String |
Description | The name of the site as it appears in the Store application. |
ACCT_NAME | String |
Description | The name on the account. This may differ from the primary contact’s name in some instances, such as a business account or a guardianship account. |
FIRST_NAME | String |
Description | The primary contact’s first name. |
LAST_NAME | String |
Description | The primary contact’s last name. |
CONTACT_ADDRESS | String |
Description | The address for the primary contact. This will include all address lines combined. |
PHONE | String |
Description | The primary contact’s primary phone number. |
String | |
Description | The primary contact’s email. This also acts as their username if eStore/eCommerce are supported. |
UNIT_NUMBER | String |
Description | The site assigned number applicable to the unit. This is not the unit ID. |
UNIT_STATUS_VAL | String |
Description | The textual value of the unit’s rental status. |
UNIT_DIMENSIONS | String |
Description | The width and depth dimensions combined in a string. |
ATTRIBUTE01 | Integer |
Description | The numeric value for the “Attribute01” custom look up as defined by the site. See eUnitAttr01 for the available values. |
ATTRIBUTE01_VAL | String |
Description | The textual value for the “Attribute01” custom lookup as defined by the site. See eUnitAttr01 for the available values. |
QUOTED_RATE | Decimal |
Description | The amount for which the quote/reservation was confirmed. This will take into account any adjusted rate and discounts. |
DISCOUNT_AMOUNT_OFFERED | Decimal |
Description | The dollar amount of any discount applicable to the quote/reservation. |
MARKET_CODE_VAL | Integer |
Description | The numeric indicator as to where the customer heard about the site. This is available to only specific sites. |
MARKET_SOURCE_VAL | String |
Description | The textual indicator as to where the customer heard about the site. This is available to only specific sites. |
INQUIRY_SOURCE | String |
Description | Indicates how the customer heard about the business. This is not required by all sites so may be null. |
CREATED | DateTime |
Description | The date that the quote reservation was originally created. |
Example
We’ll assume you’ve got a web reference, let’s name it Store, in your Visual Studio project. At this point we need to reference our objects. We’ll need the standard service object, a GetDataView_Request request object and a ParameterValues object. You will also need to pass in credentials. We can define and create those like this:
// Create a request and response objects
StoreServiceClient client = new StoreServiceClient();
GetDataView_Request request = new GetDataView_Request();
ParameterValues parms = new Store.ParameterValues();
As with every method we need to pass in credentials. We also set up the parameters for our request.
//get data view setup
client.ChannelFactory.Credentials.UserName.UserName = "user";
client.ChannelFactory.Credentials.UserName.Password = "pass";
client.ChannelFactory.Credentials.SupportInteractive = true;
parms.FilterType = 3;
parms.ParameterName = "created";
parms.ParameterValue = "01-MAR-2017";
request.OrgID = 123456;
request.SiteID = 123456;
request.ViewName = "quote_reconciliation_v";
request.Parameters = new ParameterValues[] { parms };
Finally we can call the method and pass across the login object and the request object to retrieve the data. It’s a good idea to do this in a Try Catch block.
try
{
// Call the method that will load the response object
object resp;
resp = client.GetDataView(request);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
Note that if something goes wrong the service will respond with an exception. You’ll want to take a look at that message returned in that exception so it can be debugged.
For a full list of methods see SWS2 Methods.