New Feature Forms : Possible to populate Data Collection with Insight Rest API filters ?

[d_kirsching]

Hi all, 

Do somebody tried to populate a data collection in new forms feature with Insight Rest Api ? 

https://support.atlassian.com/jira-service-management-cloud/docs/create-edit-test-or-delete-data-connections-for-forms/ 

Seems to not support '? filters' when we try to connect.

Here my query : 

https://api.atlassian.com/jsm/insight/workspace/confidential/v1/iql/objects?iql=ObjectType = "Supported MacOS Laptops" AND "status" = "offered"

and the result ( in Postman is working very well )  : 

My query without filter : 

https://api.atlassian.com/jsm/insight/workspace/confidential/v1/iql/objects

Thanks for your feedbacks and your help.

[Simon Herd · Accepted solution]

@d_kirsching in the not too distant future you will be able to add insight fields directly to your forms, but in the meantime it looks like you have discovered a bug in the data connections in ProForma (i'm the product manager for ProForma/Forms).

We have added this bug to our backlog, but there is a workaround if you encode the url yourself e.g.

https://jsonplaceholder.typicode.com/users?page="1"

would become

https://jsonplaceholder.typicode.com/users?page=%221%22

and this appears to work.

You can use a webpage such as https://www.urlencoder.io/ to do the conversion yourself.

I hope this information helps.

Regards,

Simon

[d_kirsching]

Hi  @Simon Herd 

I appreciate you're fast answer and I can confirm that the workaround provided is well.

Thanks a lot for your help.

[ian]

Hello @d_kirsching and @Simon Herd .

Sorry to resurrect this old thread but just came across it and am wondering if you are able to tell me what I need to authenticate?

I'm trying to do exactly what you are doing but can't seem to get past the authentication step. I've also asked the question here:

forms data connection insight rest authentication (atlassian.com)

I'm thinking it's only possible w/ a JWT Token because I've tried both my API token and an Insight Import token.

@Simon Herd : are you able to provide any updates on when the Forms-Insight integration will be enabled? I know roadmap says Q2-Q3.  

Thanks.

[ian]

Apologies! Worked it out. Basic auth with:

username = my email address

password = my jsm automation api token

Thought that I'd tried this combination but perhaps I was using my base64 encoded token. I am also quite new to this so probably just a noob mistake! 

Also had to use %22 in my iql query as you indicated above. Interestingly, substituting %22 for the quotes is not required in Power Automate. 

Thanks again for posting the above as I suspect I would have probably given up by now if I'd not found your posts.