topic Table to keep replicate's mapped column details in Qlik Replicate

Table to keep replicate's mapped column details

dhina — Thu, 22 Jun 2023 02:54:13 GMT

Hello Community,

Greetings!!!

I'm planning to create one SQL table/DataFrame to keep all table details of Attunity mapped columns, so I need your input on this.

1. is there any API available to get the details of Attunity mapped columns

2. If not how to proceed.

Language:

Python

Workspace:

Databricks

Table DDL:

Server String

TaskName String

TableName String

ColumnName varchar

Keycolumn boolean

Datatype varchar

Thanks in advance, Please let me know your thoughts.

Thanks,

Dhina

Re: Table to keep replicate's mapped column details

sureshkumar — Thu, 22 Jun 2023 06:36:02 GMT

Hello @dhina
Through QEM, you can call Python APIs

Kindly refer below link for list of available APIs

Enterprise Manager Python API | Qlik Enterprise Manager Help

Regards,

Suresh

Re: Table to keep replicate's mapped column details

dhina — Thu, 22 Jun 2023 06:53:16 GMT

Hello @sureshkumar ,

Thanks for the response!

I gone through the link but I couldn't find the table details/ table column details. If possible, please give me the REST API URL.

example:

https://{host}/attunityenterprisemanager/api/v1/servers/{ServerName}/tasks/{TaskName}/tables?schema={schema}&table={table}

Thanks,

Dhina

Re: Table to keep replicate's mapped column details

sureshkumar — Thu, 22 Jun 2023 07:16:41 GMT

Hello @dhina

QEM REST API link:
Enterprise Manager REST API | Qlik Enterprise Manager Help

Regards,

Suresh

Re: Table to keep replicate's mapped column details

dhina — Thu, 22 Jun 2023 07:35:47 GMT

Hello Suresh,

I couldn't find any API regarding to Table's columns details/ mapped details.

Above transformation i need it in json form. How can i get that

Re: Table to keep replicate's mapped column details

Heinvandenheuvel — Thu, 22 Jun 2023 13:02:44 GMT

There is no API for this.

See same question earlier this year:

https://community.qlik.com/t5/Qlik-Replicate/Get-column-mapping-from-Qlik-Replicate/td-p/2029856

Hein.

Re: Table to keep replicate's mapped column details

Dana_Baldwin — Wed, 28 Jun 2023 21:59:58 GMT

Hi @dhina

If one of the replies helped to resolve the issue, please mark it as a solution & like it to make it easier for others to find.
Thanks in advance!