Please let me know for each api extraction do we have to create a new connection or is there any better way.
Also right now we are pulling the apis just by entering the URL,Username and Password. We haven't used the Pagination. Without pagination do we assume we were pulling all the records in the API? Please help me on this.
1. Still now i am following the procedure like this.
I have created three different Jira connections by entering Issues ,Projects and Search APIs on URL's as separate and pulling the tables into QVDs. In the created connection I am entering only URL like https://xxxxxxxxxxxxxxx/rest/api/2/Issues and selecting Method as GET then entering username and Password.
Please confirm is this correct procedure
I found a page with a lot of information concerning REST API :
2. In the Search Api which is like below https://xxxxxxxxxxxxxxx/rest/api/2/search contains the many tables like
Customfield_10409,Customfield_11102 etc... and one Fields table contains customfield_11100 as records.
Could you please explain about this API with custom fields what is the best way to join all these tables under search api.
If you need to read a lot of tables (Customfield_10409,Customfield_11102 etc... ), QlikView generates the script for you and reads the neccessary fields. Those tables are linked to a table named [fields].
If I need to do a join afterwards, I use the LOOKUP function :
, Lookup('WATCHES', '__KEY_fields', __KEY_fields, 'JIRA_API_WATCHES') as [WATCHES]