Open Forum

 View Only
  • 1.  Retrieving transactions/orders via rest API

    Posted 05-24-2022 12:52
    Apologies if this is well documented, but I can't seem to find an answer to this.

    We are working for a client who wants to pull data from cVent into a centralized database and combine it with other systems data for reporting purposes.  We have gone through the setup and are successfully calling the rest API to get a token and then are retrieving events, attendees, contacts, and more.

    What we can't seem to locate in the API documentation is how to retrieve order information.  Our client has a report that they run from cVent that clearly provides them with transaction amounts, event, attendee name, order number, order date, order type, etc.

    It looks like admissions items tie back to this in some way, but how can we retrieve the transaction/order information via the API?  We like the rest API because our plan was to use Azure Data Factory to extract the data and then process it from there.

    There did seem to be some mention of transactions in the SOAP API documentation, but not rest API.  Are transactions only available in the SOAP API?

    Thanks for any help you can provide.
    #ReportingandInsights

    ------------------------------
    Brian Bailey
    Premiere Global Services Inc. - DevelopersUnited States
    ------------------------------


  • 2.  RE: Retrieving transactions/orders via rest API

    User Group Member
    Posted 05-27-2022 09:26
    Hi Brian, when I had used API's in a previous role we worked with our Cvent Solutions Specialist to pull API reporting. Is there a reason you need to report from the API, as you can get transaction reports within Standard reporting that is outside any API.

    ------------------------------
    Beth Vriesen
    Events Registration Admin
    Associated Bank Corporation
    ------------------------------



  • 3.  RE: Retrieving transactions/orders via rest API

    Posted 08-26-2022 03:56
    I created an idea, please upvote and share with others to upvote.
    IDEA: "Orders to be available in API / Invoice details to be available in API" 
    https://community.cvent.com/idea/orders-to-be-available-in-api-invoice-details-to-be-available-in-api

    ------------------------------
    Mila Stavreva
    Produktmanagerin
    Verlag Der Tagesspiegel GmbHGermany
    ------------------------------



  • 4.  RE: Retrieving transactions/orders via rest API

    Cvent Staff
    Posted 06-13-2022 12:05
    Hi Brian,

    For REST API, transaction data is not yet available. We encourage you to Share Your Ideas and Feature Requests with Us.

    ------------------------------
    Megan Clark
    Assistant Team Lead, Online Community Marketing
    Cvent
    ------------------------------



  • 5.  RE: Retrieving transactions/orders via rest API

    Posted 06-16-2022 14:48
    Thanks.  We have a centralized data warehouse where we pull from a variety of different systems and then load to our CRM and also feed BI reporting.  The ability to perform incremental extracts and loads is what we want to do.  It sounds like we need to go down the SOAP API path to get transactions.  Darn.  Rest API was so nice and functioning in Postman :).

    ------------------------------
    Brian Bailey
    Director
    SchroderUnited States
    ------------------------------



  • 6.  RE: Retrieving transactions/orders via rest API

    Posted 08-26-2022 03:56
    I created an idea, please upvote and share with others to upvote.
    IDEA: "Orders to be available in API / Invoice details to be available in API" 
    https://community.cvent.com/idea/orders-to-be-available-in-api-invoice-details-to-be-available-in-api

    ------------------------------
    Mila Stavreva
    Produktmanagerin
    Verlag Der Tagesspiegel GmbHGermany
    ------------------------------



  • 7.  RE: Retrieving transactions/orders via rest API

    Posted 08-26-2022 03:55
    Same need here. I created an idea, please upvote and share with others to upvote.
    IDEA: "Orders to be available in API / Invoice details to be available in API" 
    https://community.cvent.com/idea/orders-to-be-available-in-api-invoice-details-to-be-available-in-api

    ------------------------------
    Mila Stavreva
    Produktmanagerin
    Verlag Der Tagesspiegel GmbHGermany
    ------------------------------