topic Using data from Monday.com in Connectivity & Data Prep

Using data from Monday.com

Martin_Brennan — Wed, 31 May 2023 13:21:11 GMT

Hi,

Has anyone got any experience of loading data from Monday.com into Qlik sense?

If so what type of connection is needed?

I have seen articles from Monday.com about leveraging data from Qlik but not the other way around.

Many Thanks

Re: Using data from Monday.com

Chip_Matejowsky — Thu, 01 Jun 2023 19:23:09 GMT

Hi @Martin_Brennan,

I did a Google search on what types of connections monday.com allows and came across their help site article Does monday.com have an API?

I also found the following threads that show it is possible to connect to monday.com using the Qlik REST connector.

Best Regards

Re: Using data from Monday.com

techbuilders — Wed, 03 Jan 2024 13:56:34 GMT

Monday.com is actively working on their API which can have breaking changes and cause failures to ingesting data into Qlik if you're using anything besides the REST connector. We successfully pull data from Monday.com by first using PostMan to create the query > copy and paste the query into Qlik as a variable > escape the double quotes > use a WITH CONNECTION on your ETL.

When you create the REST connection, your BODY will be empty while keeping everything else, like your Query Headers (Authorization, API-version,Content-Type) in the connection itself.

Resources:

https://help.qlik.com/en-US/connectors/Subsystems/REST_connector_help/Content/Connectors_REST/Load-REST-data/Load-data.htm

https://community.qlik.com/t5/Connectivity-Data-Prep/Pagination-for-Graphql-Monday-com-data-using-Rest-Connector/td-p/1955636