Task Json Source Table Keys

egile20 — Tue, 06 Feb 2024 20:52:27 GMT

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": "Source: ADR6Class: TransparentDescription: E-Mail Addresses (Business Address Services)"
},
{
"owner": "R4S - CA MASTER",
"name": "BP001",
"orig_db_id": 2138046477,
"description": "Source: BP001Class: TransparentDescription: 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?

Re: Task Json Source Table Keys

john_wang — Wed, 07 Feb 2024 12:19:44 GMT

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.

topic Task Json Source Table Keys in Qlik Replicate

Task Json Source Table Keys

Re: Task Json Source Table Keys