WEBCentralizedShoppingCartGetEventSessionFees

Initial Build

2008.01

xWEB

Web Method

Response Type

XML results

This method returns a list of the session fees for which the specified registrant is eligible.

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 Description Datatype Notes 
oRegistration EventsRegistrantType 0(R)..1 This is the registrant for which the list of sessions fees should be provided.
oCOE CentralizedOrderEntryType 0(R)..1 This is the shopping cart which can include other items the individual is planning to purchase.

These parameters are assembled from calling other methods previously. To get a Registrant Object, call WEBCentralizedShoppingCartEventRegistrantGetNew or WEBCentralizedShoppingCartEventRegistrantGet. For the Shopping Cart Object, a new cart is created with WEBCentralizedShoppingCartGetNew, or use the already-existing cart.

Response

XML Results—A list of the session fees that the individual can select from. This list will be filtered based on the registrant's attributes and if the provided shopping cart includes any membership items, those will be considered when determining the prices available. The list will include the fee name, fee key, and fee cost, among other values. The ses_key element in the response is the primary key of a Session and can be used as a parameter to add a Session Registration in other methods.

The prc_Key property will be used later to set a value in a Fee Collection.

Name Description Datatype Notes 
prd_key Product Key string (guid syntax)
Product Product string
prd_short_description Short Description string
prc_Key Price Key string This property will be used later to set a value in a Fee.
prc_display_name Price Display Name string
ptp_key Product Type Key string (in guid syntax)
ptp_online_code Product Type Online Display Code string
Price Price string The Price (eg "25", "99.99", etc.). For whole number prices, the value might be returned without a decimal point and additional zeroes, so be sure properly convert this value to a true decimal type if needed and to format accordingly.
prc_available Available bit If available then 1, else 0.
prc_membertypeapplies Member Type Applies bit 1 or 0.
prc_status Price Status string
pat_prc_key Price Attribute Price Key string (in guid syntax)
ses_key Session Key string (in guid syntax) The primary key of a Session and can be used as a parameter to add a Session Registration in other methods.
ses_ticketed Ticketed bit If 1, then this is a ticketed session; else 0.
Capacity Capacity Count string The session's overall capacity.
_available Number Available string The number of tickets still available, if applicable.
_reserved Reserved string
_ticketed Ticketed string
_returned Returned string
Available Available string
ses_wait_list_flag Session has a wait list bit 1 if has wait list, else 0.
ses_starts Start Date Time string Session Start Date and Time in DD/MM/YYYY HH:MM:SS format.
ses_ends Session End Date Time string Session Start Date and Time in DD/MM/YYYY HH:MM:SS format.
Starts Start string
Ends Ends string
Comments Comments string
ses_registration_required Registration Fee is Required bit 1 if fee is required; 0 if not required.
Currency Currency string See Multi-Currency.
cur_key Currency Key string (in guid syntax)
ses_code Session Code string

Sample Request

<<SAMPLE REQUEST>>

Sample Response

<?xml version="1.0" encoding="utf-16"?>
<Results recordReturn="1" xmlns="http://www.avectra.com/2005/">
<Result>
<prd_key>e4b4ccce-c3ef-40ad-9e9b-f242b26cb375</prd_key>
<Product>Session1</Product>
<prd_short_description />
<prc_Key>17484084-e6d8-49bd-86ff-4c6a24a223a9</prc_Key>
<prc_display_name>Session1</prc_display_name>
<ptp_key>cb7f7aa9-9aa2-42e6-87c6-e36e1ab32afd</ptp_key>
<ptp_online_code>Event Sessions</ptp_online_code>
<Price>25</Price>
<prc_available>0</prc_available>
<prc_membertypeapplies>1</prc_membertypeapplies>
<prc_status />
<pat_prc_key>17484084-e6d8-49bd-86ff-4c6a24a223a9</pat_prc_key>
<ses_key>ac8a1ae1-bfab-4fdc-8206-4e258a089931</ses_key>
<ses_ticketed>1</ses_ticketed>
<Capacity />
<_available />
<_reserved />
<_ticketed />
<_returned />
<Available />
<ses_wait_list_flag>0</ses_wait_list_flag>
<ses_starts>1/1/1900 12:00:00 AM</ses_starts>
<ses_ends>1/1/1900 12:00:00 AM</ses_ends>
<Starts />
<Ends />
<Comments>available</Comments>
<ses_registration_required>0</ses_registration_required>
<Currency />
<cur_key />
<ses_code>Ses3</ses_code>
</Result>
</Results>
   

JSON Method

This method returns a list of the session fees that the individual can select from.

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

  • A registrant is also required. A new registrant can be created with the WEBCentralizedShoppingCartEventRegistrantGetNew method call.

  • This list will be filtered based on the registrant's attributes and if the provided shopping cart includes any membership items, those will be considered when determining the prices available.

  • The list will include the fee name, fee key, and fee cost, among other values.

  • The ses_key element in the response is the primary key of a Session and can be used as a parameter to add a Session Registration in other methods.

 

GET n/a

POST /xweb/JSON/WEBCentralizedShoppingCartGetEventSessionFees

Copy
DATA: JSON
{
    "WEBCentralizedShoppingCartGetEventSessionFees": {
        "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": "2",
        "Result": [
            {
                "prd_key": "2db8f331-a5f2-4ed2-91df-0b86ed9b993d",
                "Product": "Client Pathways Competency Bundle 11/13/20 Tampa, FL",
                "prd_short_description": null,
                "prc_Key": "de25c303-3908-4e02-bbe1-7b4a4d07f6bb",
                "prc_display_name": "Client Pathways Competency Bundle 11/13/20 Tampa, FL",
                "ptp_key": "cb7f7aa9-9aa2-42e6-87c6-e36e1ab32afd",
                "ptp_online_code": "Event Sessions",
                "Price": "0.0000",
                "prc_available": "0",
                "prc_membertypeapplies": "1",
                "prc_status": null,
                "pat_prc_key": "de25c303-3908-4e02-bbe1-7b4a4d07f6bb",
                "ses_key": "c7079e02-466e-4c4a-b2e8-1fc5e0afe287",
                "ses_ticketed": "0",
                "Capacity": null,
                "_available": null,
                "_reserved": null,
                "_ticketed": null,
                "_returned": null,
                "Available": null,
                "ses_wait_list_flag": "0",
                "ses_starts": "11/13/2020 8:00:00 AM",
                "ses_ends": "11/13/2020 12:00:00 PM",
                "Starts": "11/13/2020 8:00 AM",
                "Ends": "11/13/2020 12:00 PM",
                "Comments": "available",
                "ses_registration_required": "1",
                "cur_key": null,
                "ses_code": "S"
            },
            {
                "prd_key": "b582afa8-e2a4-48cf-8298-a2ba91dee829",
                "Product": "Client Pathways Competency Bundle 11/13/20 Tampa, FL",
                "prd_short_description": null,
                "prc_Key": "7ca50531-6443-4bda-8151-7b597de106b6",
                "prc_display_name": "Client Pathways Competency Bundle 11/13/20 Tampa, FL",
                "ptp_key": "cb7f7aa9-9aa2-42e6-87c6-e36e1ab32afd",
                "ptp_online_code": "Event Sessions",
                "Price": "0.0000",
                "prc_available": "0",
                "prc_membertypeapplies": "1",
                "prc_status": null,
                "pat_prc_key": "7ca50531-6443-4bda-8151-7b597de106b6",
                "ses_key": "8844f728-4c98-435c-bff9-6caac57eeaf4",
                "ses_ticketed": "0",
                "Capacity": null,
                "_available": null,
                "_reserved": null,
                "_ticketed": null,
                "_returned": null,
                "Available": null,
                "ses_wait_list_flag": "0",
                "ses_starts": "11/13/2020 1:00:00 PM",
                "ses_ends": "11/13/2020 5:00:00 PM",
                "Starts": "11/13/2020 1:00 PM",
                "Ends": "11/13/2020 5:00 PM",
                "Comments": "available",
                "ses_registration_required": "1",
                "cur_key": null,
                "ses_code": "S"
            }
        ]
    }
}