Home > API General, Rental/Reservation, Search > SWS2 GetDataView Method – quote_reconciliation_v

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.
EMAIL 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.

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s