How to get idalko grid values via curl

[FE Williams]

I'm able to get all values from a Jira 7 issue via curl api call to the 'issue' endpoint except for the values inside small idalko grid tables.  Does anybody have info on this?  Thanks in advance.

[francis]

(Thanks @Mohamed Benziane)

Hi @FE Williams ,

If you would need any more help - don't hesitate to send a mail to support.tge@idalko.com.

Francis

[FE Williams]

Thanks Francis, I will.

Thanks, 

Gene

[Mohamed Benziane]

Hello @FE Williams

Did you try this ?

https://wiki.idalko.com/display/TGPD/REST+API+For+Table+Grid+Editor#RESTAPIForTableGridEditor-ReadGridDataGET/rest/idalko-igrid/1.0/grid/{gridId}/issue/{issueId}/[row/{rowId}]?columns&startAt&maxResults

Regards

[FE Williams]

Thanks for your response, Mohamed.  I ran across that on the web, and I get "HTTP/1.1 404 Not Found".  Web hits make me think the problem might be that the Idalko API requires a separate installation.  I only have developer access and wanting to avoid a lengthy process to get it installed on all servers.  Also, I've seen mention of the Idalko grid being deprecated.  I was hoping to find a workaround with JQL or similar.

Thanks,

FE

[FE Williams]

Do you know if the Idalko API requires an installation?

[FE Williams]

Ah, I see it's an add-on.  I'll see about getting that installed.  Any idea if the info can be retrieved from the database with JQL?

Thanks, 

FE

[Mohamed Benziane]

Hi @FE Williams

Yes it's an addon, yes you can retrieve value in SQL.

Regards

[FE Williams]

Thanks again, Mohamed,

This is my understanding of the API endpoint for data in a particular Jira issue’s Idalko grid table:

/rest/idalko-igrid/1.0/grid/10301/issue/11359

   …with “10301” being the Idalko grid table ID and “11359” being the issue ID.   

With API, Admin, and web front end access, what is the best way to determine the Idalko grid table ID?

Also, could you point me to an example of the JQL option for listing grid IDs and for displaying data in an Idalko grid table?

[Mohamed Benziane]

Hello @FE Williams

If you want to know the ID of your table grid you can try this:

get https://Your-JIRA-URL/rest/api/2/field

It will retrieve all field with their ID's or you can use the URL, everything its describe here

Let me check my instance test and come back at you for you second question.

Sorry for my bad english.

Hope this helps

[Mohamed Benziane]

hi @FE Williams

Here the link to the documentation, you will be able to make some JQL queries to find issue that match values in your grid.

https://wiki.idalko.com/display/TGPD/Use+JQL+to+access+the+content+of+the+grid

Hope this helps

Regards