Can i use the Jira REST API to bring data from Jira into a SQL data source import?

I have a Postgresql datasource that is brining in data that contains user id(s).

I want to take these user id(s) and use the Jira REST API to look up the Jira user object so that I can pull more user related data into my repot. See attached image for more details.

1 Like

Hi @reaganpenner,

You can use the function getDocument in the JavaScipt code to call on REST API for additional data on each row. Here are more details on the function: Data adjustments using JavaScript.
However, this might be pretty resourceful if you have a significant number of rows to import and would like several attributes as separate columns.

An alternative is to add REST API as a second data source to the same data cube and import additional data to all users as properties.

Best,
Zane / Support@eazyBI.com