Qlik Sense - Cvent REST Connection

[SilviyaK]

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!

[Jay_Brown]

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!

[SilviyaK]

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! 

[Jay_Brown]

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

Hope that helps!