Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
dhina
Contributor III
Contributor III

Table to keep replicate's mapped column details

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

 

 

 

Labels (2)
1 Solution

Accepted Solutions
Heinvandenheuvel
Specialist II
Specialist II

6 Replies
sureshkumar
Support
Support

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
Contributor III
Contributor III
Author

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
Support
Support

Hello @dhina 

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

 

Regards,

Suresh

dhina
Contributor III
Contributor III
Author

Hello Suresh,

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

dhina_0-1687419310982.png

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

 

Heinvandenheuvel
Specialist II
Specialist II

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
Support
Support

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!