Skip to main content
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
egile20
Contributor II
Contributor II

Task Json Source Table Keys

I'm working on automating task modifications, specifically regarding the addition of new tables.  I have a JSON example where SAP is the source endpoint. 

"source_tables": {
"name": "SAP-SRC",
"explicit_included_tables": [
{
"owner": "R4S - CA MASTER",
"name": "ADR6",
"description": "<b>Source:</b> ADR6</br><b>Class:</b> Transparent</br><b>Description:</b> E-Mail Addresses (Business Address Services)"
},
{
"owner": "R4S - CA MASTER",
"name": "BP001",
"orig_db_id": 2138046477,
"description": "<b>Source:</b> BP001</br><b>Class:</b> Transparent</br><b>Description:</b> FS-Specific Attributes; Organization"
}}}

Within the JSON example, there are keys labeled as "orig_db_id" and "description".
1) What is the "orig_db_id" and "description" keys used for in the source table list? 
2) What would be the implications of omitting either "orig_db_id" or "description" from the task JSON? 



Labels (1)
1 Solution

Accepted Solutions
john_wang
Support
Support

Hello @egile20 ,

The two values are optional, they are retrieved from source database while exporting to the JSON file. You may omit them from the JSON file.

Hope this helps.

John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!

View solution in original post

1 Reply
john_wang
Support
Support

Hello @egile20 ,

The two values are optional, they are retrieved from source database while exporting to the JSON file. You may omit them from the JSON file.

Hope this helps.

John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!