topic Re: Qlik Sense - Cvent REST Connection in Integration, Extension & APIs

Qlik Sense - Cvent REST Connection

SilviyaK — Wed, 26 Oct 2022 06:16:43 GMT

Hi all,

Has anyone done a Qlik Sense - Cvent integration? Can you give me a list of what I need from Cvent in order to make a successful connection? My guess is that it needs to be REST connection, as Cvent is not available in the ready connectors.

Thanks!

Re: Qlik Sense - Cvent REST Connection

Jay_Brown — Tue, 01 Nov 2022 20:58:20 GMT

Hi @SilviyaK , It looks like the integration from the Cvent side does indeed utilize the REST API per their documentation. https://developer-portal.cvent.com/documentation

To start, we recommend you test this outside of Qlik in a REST client such as Postman, ARC, PowerShell, etc, and use those parameters within Qlik.

Hope that helps!

Re: Qlik Sense - Cvent REST Connection

SilviyaK — Wed, 16 Nov 2022 11:49:08 GMT

Hi Jay,

Thanks for your reply with the link. Do you maybe know what would be the best way to overcome the limitation of 100 records to be loaded from Cvent? I see that in the documentation there is a limit on this and I am struggling to get all the data I need.

Thanks!

Re: Qlik Sense - Cvent REST Connection

Jay_Brown — Fri, 18 Nov 2022 13:16:55 GMT

Hi @SilviyaK , I think it depends on the record. For example:

If you check Budget in their API guide https://developer-portal.cvent.com/documentation#tag/Budget you can see that some of these records are paginated:

List Cards: Gets a paginated list of payment card
List Budget Items: Gets a paginated list of budget items

And also you can set limits note the example limit of 100 below:

integer [ 1 .. 200 ]

Default: 100

Example: limit=100

The maximum number of records to return per page.

I'm sure their documentation has more examples of how to set up limits and pagination, but you can also reach out to them to see what to use.

More about pagination here: https://help.qlik.com/en-US/connectors/Subsystems/REST_connector_help/Content/Connectors_REST/Create-REST-connection/Loading-paged-data.htm

Hope that helps!