WEBCentralizedShoppingCartGetEventFees

Initial Build

2008.01

xWEB

Web Method

Response Type

XML Results

This method returns a list of the event Registration Fees for a particular event for which the provided registrant is eligible.

When a staff user sets up the Registration Fees in iWeb in the Event setup, ensure that any registration fees you want on xWeb are enabled to show online. Fees that aren't marked to show online will not be available for xWeb; xWeb filters Registrant Fees similarly to eWeb.

See XWeb Event Registration for a complete walk-through of how to create an Event Registration in xWeb.

Parameters

The Request contains the following parameters:

Name Type Occurs Description
oRegistration EventsRegistrantType 0(R)..1 The Registrant Object of the Registrant. This object will be the return of WEBCentralizedShoppingCartEventRegistrantGetNew or WEBCentralizedShoppingCartEventRegistrantGet.
oCOE CentralizedOrderEntryType 0(R)..1 The cart containing other items the individual is planning to purchase. Specifically, if there any memberships in this cart, those memberships may affect the fees the individual is eligible for if the customer is not currently a member.

What drives the selection of fees is the EventsRegistrantType that you pass in the oRegistration parameter (in addition to any membership(s) that might be in the cart). The specific fields in that object that help filter the eligible fees are:

  1. reg_cst_key - The Customer Key of the registrant. In practice, many events have a member and non-member fee, and the customer's membership could filter fees accordingly.
  2. reg_evt_key - The Event Key.
  3. reg_rgt_key - The Registrant Type. Registrant Types for a particular event are provided by the WEBCentralizedShoppingCartGetEventRegistrantTypeListByEvent method.
  4. reg_src_key - The Key of the Source Code, if any.

Response

XML Results—This method returns a list of the fees, including the fee name, the fee key, and the fee amount, and other information.

You'll need the value of prc_Key later on to set the prc_key property of a Fee object.

The following fields are contained in the Response:

Name Description Datatype Notes  
prd_key Product Key string (in guid syntax)
Product Product Name string
prd_short_description Short Description string
prc_Key Price Key string (in guid syntax)
prc_display_name Price Display Name string
ptp_key Product Type Key string Product Type key.
ptp_online_code Product Type Online Display Code string
pat_prc_key Price Attribute Price Key string
Currency Currency string See Multi-Currency.
Price Price string The price ("250", "99.99", etc.). Note that if the price is a whole number, the response may not include a decimal point or additional zeros. Take this into account if performing calculations or displaying the price.
prc_available Price available bit
prc_membertypeapplies Member Type Applies to Price bit
prc_status Price Status string
MemberType Member Type string A single, or a list, of Member Types that are eligible for this price. Will be [Any] if the price is eligible to any member type.</MemberType>
Category Category string
cur_key Currency Key string (in guid syntax) Currency key; related to the Currency value.

Sample Request

Parts of the request are omitted for brevity:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.avectra.com/2005/">
<soapenv:Header>
<ns:AuthorizationToken>
<ns:Token>*****</ns:Token>
</ns:AuthorizationToken>
</soapenv:Header>
<soapenv:Body>
<ns:WEBCentralizedShoppingCartGetEventFees>
<ns:oRegistration xmlns="http://www.avectra.com/2005/">
<CurrentKey/>
<Registrant>
<reg_prod_qty>0.00</reg_prod_qty>
<reg_key>237b7e38-9e19-4dad-a061-9ce6df1b8660</reg_key>
<reg_cst_key>21f1093b-fd6a-4d7f-9dc2-86cdacce3171</reg_cst_key>
<reg_evt_key>c03bb94e-210c-4a55-84dc-b9b5403ccaec</reg_evt_key>
<reg_badge_name>Darryl</reg_badge_name>
<reg_cxa_key>6d5fa945-fc84-4e6e-b35b-7c9335b2404b</reg_cxa_key>
<reg_cph_key>4a5f5e2c-141f-4177-9a46-7f9d7bad5c65</reg_cph_key>
<reg_eml_key>c926d4a4-9891-474d-b67b-c4719c26299b</reg_eml_key>
<reg_attendance_flag>1</reg_attendance_flag>
<reg_org_name_dn>Avectra</reg_org_name_dn>
<reg_adr_city>Freesburro</reg_adr_city>
<reg_key_ext>237b7e38-9e19-4dad-a061-9ce6df1b8660</reg_key_ext>
<reg_adr_state>AZ</reg_adr_state>
<reg_adr_country>UNITED STATES</reg_adr_country>
<reg_ixo_key>1d6359ac-2e0e-4189-810c-d562a2607ed2</reg_ixo_key>
<reg_registration_date>9/19/2011</reg_registration_date>
<reg_evt_guests_available>0</reg_evt_guests_available>
<reg_rgt_key></reg_rgt_key>
</Registrant>
<!-- The rest of the Registrant object's Data Objects are omitted for brevity -->
</ns:oRegistration>
<ns:oCOE xmlns="http://www.avectra.com/2005/">
<CurrentKey/>
<Invoice>
<inv_key>5a67e743-b29e-4afe-8d84-a72650388850</inv_key>
<inv_cst_key>21f1093b-fd6a-4d7f-9dc2-86cdacce3171</inv_cst_key>
<!-- The rest of the Invoice elements are omitted for brevity -->
<inv_allow_installment>0</inv_allow_installment>
</Invoice>
<!-- The rest of the Invoices object's Data Objects are omitted for brevity -->
</ns:oCOE>
</ns:WEBCentralizedShoppingCartGetEventFees>
</soapenv:Body>
</soapenv:Envelope>

Sample Response

<?xml version="1.0" encoding="utf-16"?>
<Results recordReturn="2" xmlns="http://www.avectra.com/2005/">
<Result>
<prd_key>48c7872c-1496-47f0-9ce2-f6f345f565d3</prd_key>
<Product>2010 Annual Conference</Product>
<prd_short_description />
<prc_Key>7949a59f-a354-4a29-acd2-8b56f9cdae31</prc_Key>
<prc_display_name>2010 Annual Conference</prc_display_name>
<ptp_key>64b77fb4-da34-4034-ada8-f1da796d8720</ptp_key>
<ptp_online_code>Upcoming Events</ptp_online_code>
<pat_prc_key>7949a59f-a354-4a29-acd2-8b56f9cdae31</pat_prc_key>
<Currency />
<Price>250</Price>
<prc_available>0</prc_available>
<prc_membertypeapplies>1</prc_membertypeapplies>
<prc_status />
<MemberType>[Any]</MemberType>
<Category />
<cur_key />
</Result>
<Result>
<prd_key>c89129b5-8d22-40e5-ad21-d792b5a59fbd</prd_key>
<Product>2010 Annual Conference org</Product>
<prd_short_description />
<prc_Key>af90adb7-e282-4370-8fe3-e02848557eaf</prc_Key>
<prc_display_name>2010 Annual Conference org</prc_display_name>
<ptp_key>64b77fb4-da34-4034-ada8-f1da796d8720</ptp_key>
<ptp_online_code>Upcoming Events</ptp_online_code>
<pat_prc_key>af90adb7-e282-4370-8fe3-e02848557eaf</pat_prc_key>
<Currency />
<Price>15</Price>
<prc_available>0</prc_available>
<prc_membertypeapplies>1</prc_membertypeapplies>
<prc_status />
<MemberType>[Any]</MemberType>
<Category />
<cur_key />
</Result>
</Results>
   

JSON Method

Gets fees for the event based on the registrant and the cart.

This method requires a cart. Create a new one or use an exisiting one.

If needed, create a new registrant or use an existing one.

 

GET n/a

POST /xweb/JSON/WEBCentralizedShoppingCartGetEventFees

Copy
DATA: JSON
{
    "WEBCentralizedShoppingCartGetEventFees": {
        "oRegistration": {
                "Registrant": {
                    "reg_key": "8d32464d-923c-4faf-8217-cd92668b1477",
                    "reg_cst_key": "ec8ff4c0-f5a6-4812-b313-75dd5dba8fd1",
                    "reg_evt_key": "c2bc9f98-e99c-4a28-9240-1fbd7ace4740",
                    "reg_badge_name": "Mr. JasonTest1 WattsTest1",
                    "reg_cxa_key": "3fffea6a-7c1c-4ea2-bb0c-6b8d74e4dc06",
                    "reg_eml_key": "089afd74-3495-4fce-94a0-72188210299a",
                    "reg_attendance_flag": "1",
                    "reg_adr_city": "Houston",
                    "reg_key_ext": "8d32464d-923c-4faf-8217-cd92668b1477",
                    "reg_adr_state": "TX",
                    "reg_adr_country": "UNITED STATES",
                    "reg_ixo_title_dn": "Mr. JasonTest1 WattsTest1",
                    "reg_registration_date": "2020-04-07T00:00:00-05:00",
                    "reg_prod_qty": "0.00",
                    "reg_evt_guests_available": "9999"
                },
                "Individual": {
                    "ind_cst_key": "ec8ff4c0-f5a6-4812-b313-75dd5dba8fd1",
                    "ind_prf_code": "Mr.",
                    "ind_first_name": "JasonTest1",
                    "ind_mid_name": "D",
                    "ind_last_name": "WattsTest1",
                    "ind_full_name_cp": "Mr. JasonTest1 D WattsTest1",
                    "ind_salutation_cp": "Mr. WattsTest1",
                    "ind_cst_key_ext": "ec8ff4c0-f5a6-4812-b313-75dd5dba8fd1",
                    "ind_badge_name": "Mr. JasonTest1 WattsTest1",
                    "ind_deceased_flag": "0",
                    "ind_add_date": "2020-03-27T00:06:00-05:00",
                    "ind_add_user": "jwatts",
                    "ind_delete_flag": "0",
                    "ind_position_classification_ext": "Other",
                    "ind_department_ext": "IT"
                },
                "Customer": {
                    "cst_key": "ec8ff4c0-f5a6-4812-b313-75dd5dba8fd1",
                    "cst_type": "Individual",
                    "cst_name_cp": "Mr. JasonTest1 D WattsTest1",
                    "cst_sort_name_dn": "WattsTest1 JasonTest1 D",
                    "cst_ind_full_name_dn": "Mr. JasonTest1 D WattsTest1",
                    "cst_ixo_title_dn": "Mr. JasonTest1 WattsTest1",
                    "cst_bio": "<h1>Hi!</h1>This is the bio for my test user2! <p>More text on another line2.</p>",
                    "cst_add_date": "2020-03-27T00:06:00-05:00",
                    "cst_add_user": "jwatts",
                    "cst_change_date": "2020-03-29T22:37:00-05:00",
                    "cst_change_user": "jwatts",
                    "cst_delete_flag": "0",
                    "cst_recno": "240656",
                    "cst_id": "000240656I",
                    "cst_key_ext": "ec8ff4c0-f5a6-4812-b313-75dd5dba8fd1",
                    "cst_email_text_only": "0",
                    "cst_tax_exempt_flag": "0",
                    "cst_cxa_key": "3fffea6a-7c1c-4ea2-bb0c-6b8d74e4dc06",
                    "cst_no_email_flag": "0",
                    "cst_eml_address_dn": "jwatts1980+Test1@gmail.com",
                    "cst_eml_key": "089afd74-3495-4fce-94a0-72188210299a",
                    "cst_no_phone_flag": "0",
                    "cst_no_fax_flag": "0",
                    "cst_no_web_flag": "0",
                    "cst_member_flag": "0",
                    "cst_no_msg_flag": "0",
                    "cst_web_password": "38ykB5HAqV/4arY2uJE7UbViRTA8qHhF",
                    "cst_no_mail_flag": "0",
                    "cst_web_force_password_change": "0",
                    "cst_web_login_disabled_flag": "0",
                    "cst_credit_hold_flag": "0",
                    "cst_web_forgot_password_status": "0",
                    "cst_no_publish_flag": "0",
                    "cst_salutation_1": "Mr.. JasonTest1 D WattsTest1 ",
                    "cst_salutation_2": "",
                    "cst_default_recognize_as": "Mr.. JasonTest1 D WattsTest1 ",
                    "cst_exclude_from_social_flag": "0",
                    "cst_salt": "vp76fl6vim1pvBY9v5FOn9bOt1rdmzu1",
                    "cst_iterations": "5000",
                    "cst_web_password_change_date": "2020-03-28T18:21:00-05:00",
                    "cst_web_login_locked_flag": "0",
                    "cst_credit_available": "0.00",
                    "cst_receives_member_benefits_flag": "0",
                    "cst__ind_send_mail_reset_flag": "0",
                    "cst_reset_password_flag": "0"
                },
                "Individual_X_Organization": {
                    "ixo_title": "Mr. JasonTest1 WattsTest1",
                    "ixo_primary": "1",
                    "ixo_owner": "1"
                },
                "Organization": {
                    "org_consortia_flag": "0"
                },
                "Address_XRef": {
                    "cxa_cst_key": "ec8ff4c0-f5a6-4812-b313-75dd5dba8fd1",
                    "cxa_adr_key": "c95a666a-bee2-4dbf-82a2-3ddee254af4d",
                    "cxa_add_date": "2020-03-27T00:06:00-05:00",
                    "cxa_add_user": "jwatts",
                    "cxa_change_date": "2020-03-29T22:37:00-05:00",
                    "cxa_change_user": "jwatts",
                    "cxa_delete_flag": "0",
                    "cxa_key": "3fffea6a-7c1c-4ea2-bb0c-6b8d74e4dc06",
                    "cxa_key_ext": "3fffea6a-7c1c-4ea2-bb0c-6b8d74e4dc06",
                    "cxa_on_hold_flag": "0",
                    "cxa_adt_key": "e09fc2cf-5f86-46cd-9c31-f215018ba99f",
                    "cxa_mailing_label": "Mr. JasonTest1 D WattsTest1 Mr. JasonTest1 WattsTest1 125 Main St. Houston, TX 77433",
                    "cxa_mailing_label_html": "Mr. JasonTest1 D WattsTest1<br>Mr. JasonTest1 WattsTest1<br>125 Main St.<br>Houston, TX 77433",
                    "cxa_primary": "1",
                    "cxa_owner": "1",
                    "cxa_billing": "0",
                    "cxa_create_change_log": "0"
                },
                "Address": {
                    "adr_key": "c95a666a-bee2-4dbf-82a2-3ddee254af4d",
                    "adr_cst_key_owner": "ec8ff4c0-f5a6-4812-b313-75dd5dba8fd1",
                    "adr_line1": "125 Main St.",
                    "adr_city": "Houston",
                    "adr_state": "TX",
                    "adr_post_code": "77433",
                    "adr_city_state_code": "Houston, TX 77433",
                    "adr_country": "UNITED STATES",
                    "adr_add_date": "2020-03-27T00:06:27-05:00",
                    "adr_add_user": "jwatts",
                    "adr_change_date": "2020-03-29T22:36:31-05:00",
                    "adr_change_user": "jwatts",
                    "adr_delete_flag": "0",
                    "adr_key_ext": "c95a666a-bee2-4dbf-82a2-3ddee254af4d",
                    "adr_bad_address_flag": "0",
                    "adr_no_validation_flag": "0"
                },
                "Email": {
                    "eml_key": "089afd74-3495-4fce-94a0-72188210299a",
                    "eml_address": "jwatts1980+Test1@gmail.com",
                    "eml_cst_key": "ec8ff4c0-f5a6-4812-b313-75dd5dba8fd1",
                    "eml_type": "business",
                    "eml_add_user": "jwatts",
                    "eml_add_date": "2020-03-27T00:06:25-05:00",
                    "eml_delete_flag": "0",
                    "eml_key_ext": "089afd74-3495-4fce-94a0-72188210299a",
                    "eml_invalid_flag": "0",
                    "eml_unlisted_flag": "0",
                    "eml_primary": "1"
                },
                "Website": {
                    "url_type": "internet",
                    "url_primary": "1"
                },
                "Messaging": {
                    "msg_primary": "1"
                },
                "Phone_XRef": {
                    "cph_pht_key": "88ff5661-2d14-4bdf-be4c-906c3bff7ef7",
                    "cph_primary": "1",
                    "cph_owner": "1"
                },
                "Phone": {
                    "phn_cty_key": "bc4b70f8-280e-4bb0-b935-9f728c50e183"
                },
                "Fax_XRef": {
                    "cfx_fxt_key": "6b632577-c4ef-42ac-ae19-6dfe0ddece4b",
                    "cfx_primary": "1",
                    "cfx_owner": "1"
                },
                "Fax": {
                    "fax_cty_key": "bc4b70f8-280e-4bb0-b935-9f728c50e183"
                },
                "Event": {
                    "evt_key": "c2bc9f98-e99c-4a28-9240-1fbd7ace4740",
                    "evt_code": "S",
                    "evt_etp_key": "1afedbe4-f687-465f-9dca-d97af7fac329",
                    "evt_title": "NPCB 111320 Tampa, FL",
                    "evt_capacity": "20",
                    "evt_wait_list_flag": "0",
                    "evt_registration_required": "1",
                    "evt_restricted": "0",
                    "evt_short_description": "Client Pathways Competency Bundle 11/13/20 Tampa, FL",
                    "evt_description_html": "<p>As stewards of the public trust, procurement professionals are held to a higher standard of ethics than most public employees, acting with confidence to wisely expend the taxpayer dollars. As such, procurement practitioners must serve not only as the ethical leaders of their respective entities but also as an honest and transparent representative within the larger communities they support.</p> <p><a href=\"https://www.Client.org/home/your-learning-journey/education/catalog-courses/ethics-integrity-transparency\">Ethics, Integrity &amp; Transparency Competency Module Course Description</a></p><div>&nbsp;</div> <p>While not lawyers or representatives of the legal sector, today&#8217;s public procurement professional is expected to be well versed in the application of legal limits within the procurement. As such, the aptitude of procurement professionals to comply with legislation, legal principles, and public procurement best practice guidance is critical for not just the success of the function but for the entity as a whole. </p> <p><a href=\"https://www.Client.org/home/your-learning-journey/education/catalog-courses/legislation-legal-environment \">Legislation &amp; Legal Environment Competency Module Course Description</a></p>",
                    "evt_start_date": "2020-11-13T00:00:00-06:00",
                    "evt_start_time": "8:00 AM",
                    "evt_end_date": "2020-11-13T00:00:00-06:00",
                    "evt_end_time": "5:00 PM",
                    "evt_early_registration_date": "2020-09-14T00:00:00-05:00",
                    "evt_late_registration_date": "2020-10-30T00:00:00-05:00",
                    "evt_cutoff_date": "2020-10-14T00:00:00-05:00",
                    "evt_post_to_web_date": "2020-01-09T00:00:00-06:00",
                    "evt_remove_from_web_date": "2020-11-14T00:00:00-06:00",
                    "evt_add_user": "user",
                    "evt_add_date": "2020-01-09T10:35:08-06:00",
                    "evt_change_user": "user",
                    "evt_change_date": "2020-01-09T12:35:18-06:00",
                    "evt_delete_flag": "0",
                    "evt_key_ext": "c2bc9f98-e99c-4a28-9240-1fbd7ace4740",
                    "evt_cct_key": "c32616d1-4376-4e7a-ace6-ed1626c8cd80",
                    "evt_tzn_key": "059930c3-7d4e-46d9-8a59-e3c95a2a19cd",
                    "evt_etc_key": "ef6baad0-526e-4105-a278-0cce915f5717",
                    "evt_abstract_flag": "0",
                    "evt_closed_flag": "0",
                    "evt_free_event_flag": "0",
                    "evt_regid_counter": "0",
                    "evt_free_guest_flag": "0",
                    "evt_charity_event_flag": "0",
                    "evt_activity_type_ext": "Chapter- LEAP Advanced",
                    "evt_contact_hours_ext": "7.00",
                    "evt_firsttimer_fullconf_flag_ext": "0",
                    "evt_firsttimer_confonly_flag_ext": "0",
                    "evt_n18_key_ext": "b15a09b5-e73b-40ab-b620-358dccb2553b",
                    "evt_accreditation_ext": "Accredited",
                    "evt_ceu_hours_ext": "0.80",
                    "evt_reg_payment_info_html_ext": "<h2>Course Fees / Pre-Registration Required</h2> <p><strong>Standard pricing:</strong></p> <p>Institute Members - $310 **<br /> Non-Members - $410&nbsp; **</p> <p>** Receive a $25 early registration discount by registering 60 or more days in advance of the course.&nbsp; A late fee of $50 will be assessed for those registrations received within 30 days of the course.</p> <p>Not a Client Institute member? <a href=\"http://www.Client.org/home/membership\">Click here</a> for membership information. </p><p>&nbsp;</p> <h2>Registration &amp; Payment Information</h2> <p><strong>Register online with credit card by clicking the register button below<br />Register by fax (<a href=\"http://www.Client.org/docs/default-source/New-Site/chapters/resource-center/chapter-seminar-registration-form-fy-2017.pdf?sfvrsn=2\">Download print and fax form</a>)</strong></p> <p><strong>*FORM OF PAYMENT MUST ACCOMPANY REGISTRATION FORM FOR ORDER TO BE PROCESSED</strong></p> <p><strong>Methods of Payment Accepted:</strong> Check (make checks payable to Client), Purchase Orders (via print and fax form), and Credit Cards (Master Card, Visa, and American Express).</p> <p>If paying by check, please make check payable to Client and send payment to:</p> <p>Client, Attn: Seminar Registration<br />2411 Dulles Corner Park, Suite 350<br />Herndon, VA 20171</p>",
                    "evt_cancel_policy_html_ext": "<h2>Client Course Cancellation Policy</h2> <p>Registration and payment must be received 30 days prior to the seminar start date. After this time, registrations will be based on space availability.&nbsp; A full refund, less a <strong>$75 administrative fee</strong> will be given for cancellations made in writing 31+ days prior to the seminar date by emailing <a href=\"&#109;&#97;&#105;&#108;&#116;&#111;&#58;&#82;&#101;&#103;&#105;&#115;&#116;&#114;&#97;&#116;&#105;&#111;&#110;&#73;&#110;&#102;&#111;&#64;&#110;&#105;&#103;&#112;&#46;&#111;&#114;&#103;\">RegistrationInfo@Client.org</a>. No refunds are given for cancellations received within 30 days of the seminar start date. There are no refunds for no-shows. If the seminar is cancelled for any reason, Client's liability is limited to the registration fee only. </p><p>Attendee substitutions within the same agency may be done at any time with email notification to Client. If attending via scholarship, please provide documentation verifying the scholarship issuer's name and contact information in lieu of payment information.</p>",
                    "evt_local_info_ext": "<h2>Local Information</h2> <p>If you would like more information on the event, please contact the local Seminar Coordinator, Stephanie Swinson via email at <a href=\"mailto:\">stephanie.swinson@stpete.org</a></p><div>Hotel Suggestions:</div><div>&nbsp;</div><div>Hampton Inn &amp; Suites</div><div>Hilton Garden Inn, Tampa - Ybor Historic District</div><div>Hilton Downtown Tampa&nbsp;</div>",
                    "evt_registered": "0",
                    "evt_onwaitlist": "0",
                    "evt_available": "20",
                    "evt_remaining": "20",
                    "evt_available_new": "20",
                    "evt_Registered_main_count": "0",
                    "evt_waitList_main_count": "0",
                    "evt_has_fees_flag": "1",
                    "evt_has_products_flag": "0",
                    "evt_Registered_guest_count": "0",
                    "evt_has_demographics_flag": "0",
                    "evt_has_housing_flag": "0",
                    "evt_waitList_guest_count": "0",
                    "evt_has_tracks_flag": "0",
                    "evt_has_sessions_flag": "1",
                    "evt_payables_batch_suffix": "BATCH"
                },
                "Event_Location": null,
                "Location": null,
                "Location_Customer_Address": null,
                "Location_Address": {
                    "ad2__adr_state": "NULL",
                    "ad2__adr_country": "UNITED STATES"
                },
                "Location_Phone_XRef": {
                    "cp2__cph_pht_key": "88ff5661-2d14-4bdf-be4c-906c3bff7ef7"
                },
                "Location_Website": {
                    "ur2__url_type": "internet"
                },
                "Event_Location_Room_Type": null,
                "Room_Request": null,
                "Registrant_Housing": null,
                "RegistrantGuest": {
                    "rg2__reg_attendance_flag": "1",
                    "rg2__reg_adr_state": "NULL",
                    "rg2__reg_adr_country": "UNITED STATES",
                    "rg2__reg_registration_date": "2020-04-07T00:00:00-05:00"
                },
                "Invoice": {
                    "inv_print_count": "0",
                    "inv_ship_priority": "3",
                    "inv_AutoRefund": "0",
                    "inv_eweb_credit_available": "0.00",
                    "inv_eweb_apply_credit_amount": "0.00",
                    "inv_total": "0.00",
                    "inv_amount": "0.00",
                    "inv_balance": "0.00",
                    "inv_payment_to_apply_distributed": "0.00",
                    "inv_close_opportunity": "0",
                    "inv_credit_to_apply_distributed": "0.00",
                    "inv_distributable_credit_total": "0.00",
                    "inv_distributable_credit_balance": "0.00",
                    "inv_paid_by_liability_balance": "0.00",
                    "inv_payment_to_apply": "0.00",
                    "inv_nettotal": "0.00",
                    "inv_netpayment": "0.00",
                    "inv_credit_to_apply": "0.00",
                    "inv_netbalance": "0.00",
                    "inv_netcredit": "0.00",
                    "inv_net_amount_due": "0.00",
                    "inv_netunpaidbalance": "0.00",
                    "inv_netwriteoff": "0.00",
                    "inv_writeoff_to_apply": "0.00",
                    "inv_netreturn": "0.00",
                    "inv_return_to_apply": "0.00",
                    "inv_netapplied": "0.00",
                    "inv_previous_netapplied": "0.00",
                    "inv_previous_netpayment": "0.00",
                    "inv_total_to_apply": "0.00",
                    "inv_allow_payment_with_frozen_payment_method": "0",
                    "inv_select_all": "0",
                    "inv_autoapply": "0",
                    "inv_autoapplypayment": "0",
                    "inv_installment_flag": "0",
                    "inv_coe_flag": "0",
                    "inv_shippable_total": "0.00",
                    "inv_unapplied_shipping_total": "0.00",
                    "inv_shippable_items_flag": "0",
                    "inv_autoapplycredit": "0",
                    "inv_invoice_detail_count": "0",
                    "inv_bill_me": "0",
                    "inv_HasNewLineItems": "0",
                    "inv_HasOldLineItems": "0",
                    "inv_total_weight": "0.00",
                    "inv_discount": "0.00",
                    "inv_shipping": "0.00",
                    "inv_tax": "0.00",
                    "inv_prd_keys": "NULL"
                },
                "Payment": null,
                "Payment_Info": {
                    "pin_hosted_page_available": "0",
                    "pin_mobile_app_available": "0",
                    "pin_hosted_payment": "0",
                    "pin_isvault": "0",
                    "pin_tax_amt": "0.00",
                    "pin_billing_info_required_for_ach_flag": "0",
                    "pin_allow_online_payment_flag": "0",
                    "pin_preferred_flag": "0"
                },
                "Payment_Method": null,
                "Product": {
                    "prd_atc_key": "7697205e-876a-436a-ae35-9ba3abf05a22"
                },
                "Price": {
                    "prc_price": "0.00",
                    "prc_deferred_flag": "0",
                    "prc_renew_unpaid_orders_flag": "1",
                    "prc_allow_unpaid_orders_flag": "1"
                },
                "Registrant_Type": null,
                "Registrant_Custom_Demographics": null,
                "Gift": {
                    "gft_recognition_customer_adr_country": "UNITED STATES",
                    "gft_stock_high": "0.00",
                    "gft_stock_low": "0.00"
                },
                "source_code": null,
                "Registrant_Session": {
                    "rgs_attendance_flag": "1",
                    "rgs_cancel_qty": "0",
                    "rgs_lms_status_ext": "Not Enrolled"
                },
                "Registrant_SessionCollection": null,
                "Invoice_DetailCollection": null,
                "Additional_Invoice_DetailCollection": null
        },
        "oCOE": {
                "Invoice": {
                    "inv_key": "8d4e43c0-8e21-4ea3-bae7-2c9d4468e654",
                    "inv_cst_key": "ec8ff4c0-f5a6-4812-b313-75dd5dba8fd1",
                    "inv_print_count": "0",
                    "inv_ship_priority": "3",
                    "inv_orig_trans_type": "prepaid",
                    "inv_cxa_key": "3fffea6a-7c1c-4ea2-bb0c-6b8d74e4dc06",
                    "inv_eml_key": "089afd74-3495-4fce-94a0-72188210299a",
                    "inv_cst_billing_key": "ec8ff4c0-f5a6-4812-b313-75dd5dba8fd1",
                    "inv_AutoRefund": "0",
                    "inv_eweb_credit_available": "0.00",
                    "inv_eweb_apply_credit_amount": "0.00",
                    "inv_first_installment_amount": "0.00",
                    "inv_cst_first_last_name": "JasonTest1 D WattsTest1",
                    "inv_total": "0.00",
                    "inv_amount": "0.00",
                    "inv_balance": "0.00",
                    "inv_Donation_in_cart": "0",
                    "inv_payment_to_apply_distributed": "0.00",
                    "inv_batch_total": "$0.00",
                    "inv_batch_total_diff": "$0.00",
                    "inv_close_opportunity": "0",
                    "inv_credit_to_apply_distributed": "0.00",
                    "inv_batch_count": "0",
                    "inv_batch_count_diff": "0",
                    "inv_distributable_credit_total": "0.00",
                    "inv_bat_control_total_display": "0.00",
                    "inv_distributable_credit_balance": "0.00",
                    "inv_invoice_to_pay_count": "0",
                    "inv_paid_by_liability_balance": "0.00",
                    "inv_payment_detail_count": "0",
                    "inv_payment_to_apply": "0.00",
                    "inv_nettotal": "0.00",
                    "inv_netpayment": "0.00",
                    "inv_credit_to_apply": "0.00",
                    "inv_netbalance": "0.00",
                    "inv_netcredit": "0.00",
                    "inv_net_amount_due": "0.00",
                    "inv_netunpaidbalance": "0.00",
                    "inv_netwriteoff": "0.00",
                    "inv_writeoff_to_apply": "0.00",
                    "inv_netreturn": "0.00",
                    "inv_return_to_apply": "0.00",
                    "inv_netapplied": "0.00",
                    "inv_previous_netapplied": "0.00",
                    "inv_previous_netpayment": "0.00",
                    "inv_total_to_apply": "0.00",
                    "inv_allow_recurring": "1",
                    "inv_allow_payment_with_frozen_payment_method": "0",
                    "inv_select_all": "0",
                    "inv_autoapply": "1",
                    "inv_autoapplypayment": "1",
                    "inv_installment_flag": "0",
                    "inv_coe_flag": "0",
                    "inv_shippable_total": "0.00",
                    "inv_unapplied_shipping_total": "0.00",
                    "inv_shippable_items_flag": "0",
                    "inv_autoapplycredit": "0",
                    "inv_invoice_detail_count": "0",
                    "inv_bill_me": "0",
                    "inv_HasNewLineItems": "0",
                    "inv_HasOldLineItems": "0",
                    "inv_total_weight": "0.00",
                    "inv_discount": "0.00",
                    "inv_shipping": "0.00",
                    "inv_tax": "0.00",
                    "inv_prd_keys": "NULL",
                    "inv_Show_Popup": "0",
                    "inv_convert_to_installmentpayments": "0",
                    "inv_allow_installment": "0"
                },
                "Invoice_Detail": {
                    "ivd_parity": "1",
                    "ivd_cxa_key": "3fffea6a-7c1c-4ea2-bb0c-6b8d74e4dc06",
                    "ivd_type": "Product"
                },
                "Invoice_Detail_Term": null,
                "Claim": {
                    "cld_claim_status": "Approved"
                },
                "Default_Shipping_Address": {
                    "cxs__cxa_cst_key": "ec8ff4c0-f5a6-4812-b313-75dd5dba8fd1",
                    "cxs__cxa_adr_key": "c95a666a-bee2-4dbf-82a2-3ddee254af4d",
                    "cxs__cxa_add_date": "2020-03-27T00:06:00-05:00",
                    "cxs__cxa_add_user": "jwatts",
                    "cxs__cxa_change_date": "2020-03-29T22:37:00-05:00",
                    "cxs__cxa_change_user": "jwatts",
                    "cxs__cxa_delete_flag": "0",
                    "cxs__cxa_key": "3fffea6a-7c1c-4ea2-bb0c-6b8d74e4dc06",
                    "cxs__cxa_key_ext": "3fffea6a-7c1c-4ea2-bb0c-6b8d74e4dc06",
                    "cxs__cxa_on_hold_flag": "0",
                    "cxs__cxa_adt_key": "e09fc2cf-5f86-46cd-9c31-f215018ba99f",
                    "cxs__cxa_mailing_label": "Mr. JasonTest1 D WattsTest1 Mr. JasonTest1 WattsTest1 125 Main St. Houston, TX 77433",
                    "cxs__cxa_mailing_label_html": "Mr. JasonTest1 D WattsTest1<br>Mr. JasonTest1 WattsTest1<br>125 Main St.<br>Houston, TX 77433"
                },
                "Payment": {
                    "pay_cst_key": "ec8ff4c0-f5a6-4812-b313-75dd5dba8fd1"
                },
                "Payment_Info": {
                    "pin_cst_key": "ec8ff4c0-f5a6-4812-b313-75dd5dba8fd1",
                    "pin_street": "125 Main St.",
                    "pin_city": "Houston",
                    "pin_state": "TX",
                    "pin_zip": "77433",
                    "pin_email": "jwatts1980+Test1@gmail.com",
                    "pin_cty_iso_number": "840",
                    "pin_hosted_page_available": "0",
                    "pin_mobile_app_available": "0",
                    "pin_hosted_payment": "0",
                    "pin_isvault": "0",
                    "pin_tax_amt": "0.00",
                    "pin_billing_info_required_for_ach_flag": "0",
                    "pin_allow_online_payment_flag": "0",
                    "pin_preferred_flag": "0"
                },
                "Payment_Method": null,
                "Customer": {
                    "cst_key": "ec8ff4c0-f5a6-4812-b313-75dd5dba8fd1",
                    "cst_type": "Individual",
                    "cst_name_cp": "Mr. JasonTest1 D WattsTest1",
                    "cst_sort_name_dn": "WattsTest1 JasonTest1 D",
                    "cst_ind_full_name_dn": "Mr. JasonTest1 D WattsTest1",
                    "cst_ixo_title_dn": "Mr. JasonTest1 WattsTest1",
                    "cst_bio": "<h1>Hi!</h1>This is the bio for my test user2! <p>More text on another line2.</p>",
                    "cst_add_date": "2020-03-27T00:06:00-05:00",
                    "cst_add_user": "jwatts",
                    "cst_change_date": "2020-03-29T22:37:00-05:00",
                    "cst_change_user": "jwatts",
                    "cst_delete_flag": "0",
                    "cst_recno": "240656",
                    "cst_id": "000240656I",
                    "cst_key_ext": "ec8ff4c0-f5a6-4812-b313-75dd5dba8fd1",
                    "cst_email_text_only": "0",
                    "cst_tax_exempt_flag": "0",
                    "cst_cxa_key": "3fffea6a-7c1c-4ea2-bb0c-6b8d74e4dc06",
                    "cst_no_email_flag": "0",
                    "cst_eml_address_dn": "jwatts1980+Test1@gmail.com",
                    "cst_eml_key": "089afd74-3495-4fce-94a0-72188210299a",
                    "cst_no_phone_flag": "0",
                    "cst_no_fax_flag": "0",
                    "cst_no_web_flag": "0",
                    "cst_member_flag": "0",
                    "cst_no_msg_flag": "0",
                    "cst_web_password": "38ykB5HAqV/4arY2uJE7UbViRTA8qHhF",
                    "cst_no_mail_flag": "0",
                    "cst_web_force_password_change": "0",
                    "cst_web_login_disabled_flag": "0",
                    "cst_credit_hold_flag": "0",
                    "cst_web_forgot_password_status": "0",
                    "cst_no_publish_flag": "0",
                    "cst_salutation_1": "Mr.. JasonTest1 D WattsTest1 ",
                    "cst_salutation_2": "",
                    "cst_default_recognize_as": "Mr.. JasonTest1 D WattsTest1 ",
                    "cst_exclude_from_social_flag": "0",
                    "cst_salt": "vp76fl6vim1pvBY9v5FOn9bOt1rdmzu1",
                    "cst_iterations": "5000",
                    "cst_web_password_change_date": "2020-03-28T18:21:00-05:00",
                    "cst_web_login_locked_flag": "0",
                    "cst_credit_available": "0.00"
                },
                "CustomerIndividual": {
                    "ind_cst_key": "ec8ff4c0-f5a6-4812-b313-75dd5dba8fd1",
                    "ind_prf_code": "Mr.",
                    "ind_first_name": "JasonTest1",
                    "ind_mid_name": "D",
                    "ind_last_name": "WattsTest1",
                    "ind_full_name_cp": "Mr. JasonTest1 D WattsTest1",
                    "ind_salutation_cp": "Mr. WattsTest1",
                    "ind_cst_key_ext": "ec8ff4c0-f5a6-4812-b313-75dd5dba8fd1",
                    "ind_badge_name": "Mr. JasonTest1 WattsTest1",
                    "ind_deceased_flag": "0",
                    "ind_add_date": "2020-03-27T00:06:00-05:00",
                    "ind_add_user": "jwatts",
                    "ind_delete_flag": "0",
                    "ind_position_classification_ext": "Other",
                    "ind_department_ext": "IT"
                },
                "Billing_Address": {
                    "cxa_cst_key": "ec8ff4c0-f5a6-4812-b313-75dd5dba8fd1",
                    "cxa_adr_key": "c95a666a-bee2-4dbf-82a2-3ddee254af4d",
                    "cxa_add_date": "2020-03-27T00:06:00-05:00",
                    "cxa_add_user": "jwatts",
                    "cxa_change_date": "2020-03-29T22:37:00-05:00",
                    "cxa_change_user": "jwatts",
                    "cxa_delete_flag": "0",
                    "cxa_key": "3fffea6a-7c1c-4ea2-bb0c-6b8d74e4dc06",
                    "cxa_key_ext": "3fffea6a-7c1c-4ea2-bb0c-6b8d74e4dc06",
                    "cxa_on_hold_flag": "0",
                    "cxa_adt_key": "e09fc2cf-5f86-46cd-9c31-f215018ba99f",
                    "cxa_mailing_label": "Mr. JasonTest1 D WattsTest1 Mr. JasonTest1 WattsTest1 125 Main St. Houston, TX 77433",
                    "cxa_mailing_label_html": "Mr. JasonTest1 D WattsTest1<br>Mr. JasonTest1 WattsTest1<br>125 Main St.<br>Houston, TX 77433"
                },
                "Billing_Adr": {
                    "adr_key": "c95a666a-bee2-4dbf-82a2-3ddee254af4d",
                    "adr_cst_key_owner": "ec8ff4c0-f5a6-4812-b313-75dd5dba8fd1",
                    "adr_line1": "125 Main St.",
                    "adr_city": "Houston",
                    "adr_state": "TX",
                    "adr_post_code": "77433",
                    "adr_city_state_code": "Houston, TX 77433",
                    "adr_country": "UNITED STATES",
                    "adr_add_date": "2020-03-27T00:06:27-05:00",
                    "adr_add_user": "jwatts",
                    "adr_change_date": "2020-03-29T22:36:31-05:00",
                    "adr_change_user": "jwatts",
                    "adr_delete_flag": "0",
                    "adr_key_ext": "c95a666a-bee2-4dbf-82a2-3ddee254af4d",
                    "adr_bad_address_flag": "0",
                    "adr_no_validation_flag": "0"
                },
                "Price": {
                    "prc_price": "0.00",
                    "prc_deferred_flag": "0",
                    "prc_renew_unpaid_orders_flag": "1",
                    "prc_allow_unpaid_orders_flag": "1"
                },
                "Batch": {
                    "bat_control_total": "0.00",
                    "bat_control_trx_count": "0",
                    "bat_post_flag": "0",
                    "bat_export_flag": "0",
                    "bat_atc_key": "7697205e-876a-436a-ae35-9ba3abf05a22",
                    "bat_make_default_flag": "0"
                },
                "BillToCustomer": {
                    "bcs__cst_key": "ec8ff4c0-f5a6-4812-b313-75dd5dba8fd1",
                    "bcs__cst_type": "Individual",
                    "bcs__cst_name_cp": "Mr. JasonTest1 D WattsTest1",
                    "bcs__cst_sort_name_dn": "WattsTest1 JasonTest1 D",
                    "bcs__cst_ind_full_name_dn": "Mr. JasonTest1 D WattsTest1",
                    "bcs__cst_ixo_title_dn": "Mr. JasonTest1 WattsTest1",
                    "bcs__cst_bio": "<h1>Hi!</h1>This is the bio for my test user2! <p>More text on another line2.</p>",
                    "bcs__cst_add_date": "2020-03-27T00:06:00-05:00",
                    "bcs__cst_add_user": "jwatts",
                    "bcs__cst_change_date": "2020-03-29T22:37:00-05:00",
                    "bcs__cst_change_user": "jwatts",
                    "bcs__cst_delete_flag": "0",
                    "bcs__cst_recno": "240656",
                    "bcs__cst_id": "000240656I",
                    "bcs__cst_key_ext": "ec8ff4c0-f5a6-4812-b313-75dd5dba8fd1",
                    "bcs__cst_email_text_only": "0",
                    "bcs__cst_tax_exempt_flag": "0",
                    "bcs__cst_cxa_key": "3fffea6a-7c1c-4ea2-bb0c-6b8d74e4dc06",
                    "bcs__cst_no_email_flag": "0",
                    "bcs__cst_eml_address_dn": "jwatts1980+Test1@gmail.com",
                    "bcs__cst_eml_key": "089afd74-3495-4fce-94a0-72188210299a",
                    "bcs__cst_no_phone_flag": "0",
                    "bcs__cst_no_fax_flag": "0",
                    "bcs__cst_no_web_flag": "0",
                    "bcs__cst_member_flag": "0",
                    "bcs__cst_no_msg_flag": "0",
                    "bcs__cst_web_password": "38ykB5HAqV/4arY2uJE7UbViRTA8qHhF",
                    "bcs__cst_no_mail_flag": "0",
                    "bcs__cst_web_force_password_change": "0",
                    "bcs__cst_web_login_disabled_flag": "0",
                    "bcs__cst_credit_hold_flag": "0",
                    "bcs__cst_web_forgot_password_status": "0",
                    "bcs__cst_no_publish_flag": "0",
                    "bcs__cst_salutation_1": "Mr.. JasonTest1 D WattsTest1 ",
                    "bcs__cst_salutation_2": "",
                    "bcs__cst_default_recognize_as": "Mr.. JasonTest1 D WattsTest1 ",
                    "bcs__cst_exclude_from_social_flag": "0",
                    "bcs__cst_salt": "vp76fl6vim1pvBY9v5FOn9bOt1rdmzu1",
                    "bcs__cst_iterations": "5000",
                    "bcs__cst_web_password_change_date": "2020-03-28T18:21:00-05:00",
                    "bcs__cst_web_login_locked_flag": "0"
                },
                "BillToCustomerIndividual": {
                    "bin__ind_cst_key": "ec8ff4c0-f5a6-4812-b313-75dd5dba8fd1",
                    "bin__ind_prf_code": "Mr.",
                    "bin__ind_first_name": "JasonTest1",
                    "bin__ind_mid_name": "D",
                    "bin__ind_last_name": "WattsTest1",
                    "bin__ind_full_name_cp": "Mr. JasonTest1 D WattsTest1",
                    "bin__ind_salutation_cp": "Mr. WattsTest1",
                    "bin__ind_cst_key_ext": "ec8ff4c0-f5a6-4812-b313-75dd5dba8fd1",
                    "bin__ind_badge_name": "Mr. JasonTest1 WattsTest1",
                    "bin__ind_deceased_flag": "0",
                    "bin__ind_add_date": "2020-03-27T00:06:00-05:00",
                    "bin__ind_add_user": "jwatts",
                    "bin__ind_delete_flag": "0",
                    "bin__ind_position_classification_ext": "Other",
                    "bin__ind_department_ext": "IT"
                },
                "Billing_Contact": null,
                "InstallmentBilling": {
                    "ord_proforma": "0"
                },
                "Company-Business_Unit": {
                    "atc_code": "ACC",
                    "atc_name": "National Institute of Governmental Purchasing",
                    "atc_asn_code": "ACC",
                    "atc_add_user": "av_Bwoehrle",
                    "atc_add_date": "2008-02-25T13:41:44-06:00",
                    "atc_change_user": "user",
                    "atc_change_date": "2017-03-20T10:20:19-05:00",
                    "atc_delete_flag": "0",
                    "atc_key": "7697205e-876a-436a-ae35-9ba3abf05a22",
                    "atc_key_ext": "7697205e-876a-436a-ae35-9ba3abf05a22",
                    "atc_gla_overpayment_key": "c6ce750a-c916-4f8a-9406-fdbcecc198a5",
                    "atc_ait_key": "aa8965fb-42ef-494c-8d92-03b0571865bc",
                    "atc_tax_id": "53-0196623"
                },
                "Credit_Available": {
                    "caa_cst_key": "ec8ff4c0-f5a6-4812-b313-75dd5dba8fd1",
                    "caa_cst_credit_available": "0.00"
                },
                "source_code": null,
                "Sales_Opportunity": {
                    "sfo_quantity": "1.0000",
                    "sfo_amount": "0.00"
                },
                "currency": {
                    "cur_separator": ",",
                    "cur_calc_method": "multiply",
                    "cur_fraction_separator": "."
                },
                "Invoice_DetailCollection": null,
                "Additional_Invoice_DetailCollection": null,
                "MembershipCollection": null,
                "RegistrantCollection": null,
                "Group_RegistrantionCollection": null,
                "GiftCollection": null,
                "InvoiceToPayCollection": null,
                "ExhibitorCollection": null,
                "Accreditation_ApplicantCollection": null
        }
    }
}

 

Copy
SAMPLE RESULT
HTTP STATUS: 200
DATA: JSON
{
    "Results": {
        "@recordReturn": "1",
        "Result": [
            {
                "prd_key": "65b8d198-d23d-4d86-b74d-6f2cd5e1d917",
                "Product": "Non-Member: Early",
                "prd_short_description": null,
                "prc_Key": "8412f825-4d54-4128-8b8b-d714274f1177",
                "prc_display_name": "Non-Member: Early",
                "ptp_key": "64b77fb4-da34-4034-ada8-f1da796d8720",
                "ptp_online_code": "Upcoming Events",
                "pat_prc_key": "8412f825-4d54-4128-8b8b-d714274f1177",
                "Price": "385.0000",
                "prc_available": "0",
                "prc_membertypeapplies": "1",
                "prc_status": null,
                "MemberType": "[Any]",
                "Category": null,
                "cur_key": null
            }
        ]
    }
}

 

 

FAQ

Not Getting Any Fees

If you're not seeing any fees, it probably relates to the Registration Fee setup in iWeb. For a Fee to appear in this method, the following conditions must be met:

  • The Fee must be marked to show online.
  • If there are dates on the Fees, the date range must be inclusive of the system date.

Fault in Method Parameter

If you get an exception like this, it is likely that you haven't set the namespace properly. See XWeb Namespace for more information.

<XWebException>
<Message>Fault in method parameter.</Message>
<MessageDetail>Error converting data type varchar to uniqueidentifier.</MessageDetail>
<UserMessage/>
<Number>-2147217913</Number>
<Source>xWebClasses</Source>
<Class/>
<Library/>
<Method/>
<Line>0</Line>
<StackTrace>
at Avectra.netForum.xWeb.FacadeData.DataSetToXmlFacadeNode(OleDbDataReader oDR, DataSet inputDS, String szObjectName, String szQueryString, FacadeClass oParentFacade, String WithDescriptions, XmlDocument xElements)
at Avectra.netForum.xWeb.FacadeData.GetQueryNode(String szObjectName, String szColumnList, String szWhereClause, String szOrderBy, Int32 nRecordReturnLimit, DataSet inputDS)
at Avectra.netForum.xWeb.xWebSecure.netForumXMLSecure.WEBCentralizedShoppingCartGetEventFees(Registration oRegistration, OrderEntry oCOE)
</StackTrace>
<SQLCommand>dbo.ev_registrant_select_event_fees @cst_key='',@fee_evt_key='',@pat_rgt_key=null,@pat_src_key=null,@reg_date='9/19/2011',@eweb=1,@num_registrants=1</SQLCommand>
<ErrorType>GeneralError</ErrorType>
<ErrorKey>a218bc7c-d920-4502-8537-072a8c389ded</ErrorKey>
<Errors/>
</XWebException>