REST:API with POST to Monday.com

Questions & Answers
1

Hi,

I’m trying to get a collection of items from a Monday’s board.
Can someone please help me figure out why it doesn’t work?

This query works in monday.com/developers/v2/try-it-yourself:
query { boards(ids: XXXXXX) { items(limit: 10) { name } } }

In easyBi:

Source: https://api.monday.com/v2/
Request method: POST
Request body: {“query”: “{ boards(ids: XXXXXX) { items(limit: 10) { name } }”}
HTTP Header: Authorization
Header value: Bearer xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Content type: JSON

Very simple query which returns first 10 titles to test the query.
What am I doing wrong here?

Thank you!

2

Hi @MikeS,

Do you get an error or get redirected to an empty data mapping screen?

Best regards,
Jānis Baiža
eazyBI developer

3

Hi @MikeS ,

It seems that you have a missing “}” in your eazyBI request body.
The following returned data for me:

{"query": "{ boards(ids: [board_id]) { items(limit: 10) { name } } }"}

Regards,
Jānis

4

Hey @janis.baiza ,

Thanks a lot for prompt reply!
I don’t even reach the data mapping screen!
Continuous spinning until it raises the error: execution expired

Well, I’m still stuck. See my config:

image
image784×1237 44.3 KB

Anything to add?

5

Hi @MikeS,

If you are using eazyBI on the Jira Server/Data Center, could it be that outgoing network connections are disabled for your Jira server?
If network connections are allowed, please send eazyBI log files (Troubleshooting) to our support email support@eazybi.com.

Best regards,
Jānis

6

Hey @janis.baiza,

You are right, we use Jira Data Center edition. I’ll check with admins.
Thanks again for your support!
I’ll give feedback ASAP.

Best

7

Hey @janis.baiza,

So, that was the issue! Had to whitelist the connection using Jira Data center.
Thanks a lot for your support!

Best regards,

8

Hi @MikeS ,

Thank you for confirming that the network restrictions were the reason for the error.

Regards,
Jānis
P.S. We have a separate app for monday.com data analysis - https://monday.com/marketplace/10000162.
Also, I added your reference to an internal improvement request to enable monday.com data import into eazyBI for Jira Data Center.