Join Imported Tables
I created a rest connector to import JIRA data but it's broken up lower level data within an object into different tables (ex. changelog, comments, etc.). I'm unable to use _id or id to join them back to the main table. I tried using the IncludeList to include relevant fields in one table but that does not work after the first level. Please advise how I should proceed.
{
"Settings": {
"Provider": "rest.jira2019Q1.connector",
"DisplayName": "Jira 2019 Q1",
"MaxDocs": 100,
"FetchSize": 1000000,
"Parameters": {
"BasicToken": "a2l0dHlAdW5pZmllZC5jb206SjNqZlRUc09KTTdKUmd2ZENHZjU3NjdB"
}
},
"Tables": [
{
"Name": "Issues",
"Schema": "Https",
"Public": "True",
"Method": "GET",
"Base": "https://blahblah.jira.com",
"Path": "/rest/api/3/search",
"Headers": {
"Authorization": "Basic [@Settings.Parameters.BasicToken]"
},
"DataPath": "issues",
"PathParameters": [],
"QueryParameters": {
"jql": "project in (PS,UIP,UNP) AND labels in (maintenance, jira_maintenance, backfill) AND createdDate >= 2019-01-01
AND createdDate <= 2019-03-31 ORDER BY createdDate",
"expand": "changelog",
"fields": "comment,issuetype,status,created,names,assignee",
"startAt": 0
},
"Transformation": {
"IncludeList": [
"id",
"key",a
"changelog",
"fields"
],
},
"PagingConfig": {
"Type": "URL",
"KeepUrl": "true",
"NextPage": "${[@Tables.Issues.@.startAt] + 50}",
"QueryParameters": {
"jql": "project in (PS,UIP,UNP) AND labels in (maintenance, jira_maintenance, backfill) AND createdDate > 2019-03-01
ORDER BY createdDate",
"expand": "changelog",
"fields": "comment,issuetype,status,created,names,assignee",
"startAt": "[@nextpage]"
}
},
"Body": {},
"DataFormat": "Json"
}
]
}
-
Hi Kitty,
I moved your post to the Data Connectors forum, as the "REST API" forum is intended for discussions of the Sisense REST API, not the REST connector, and I believe you wouldn't be able to get an answer there. I can see how those two would be confusing!
I do suggest if this thread does not get a reply within the next couple of days that you open a ticket with Sisense Support. If you do find a solution elsewhere (via support or otherwise) I would appreciate it if you could post it here, as I believe others will benefit from it as well!
-
I am having the same issue. Initially the _id field matched in the base table and the table for the lower level object table but now it is creating a different _id value for the same record in the lower level object table so there is no way to join. I cannot figure out why/how this changed. I am currently importing only one record for testing. the images below are for the base table and the second is for the lower level object table. the _id field values should all be the same???
Please sign in to leave a comment.
Comments
2 comments