Table to keep replicate's mapped column details

[dhina]

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

[sureshkumar]

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

[dhina]

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=...

Thanks,

Dhina

[sureshkumar]

Hello @dhina 

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

Regards,

Suresh

[dhina]

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

[Heinvandenheuvel · Accepted solution]

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.

[Dana_Baldwin]

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!