Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to build a program to get list of tasks, from the task to get list of schemas and relative tables.
I am able to get list of tasks.
However, when I am trying to get list of tables for the specific task, I have defined schema and table in the Api call.
My objective is to get the schema and table from the task. Defining them just doesn't feel right to me.
I am referring the below documentation and have configured AEM_CLIENT
Enterprise Manager Python API | Qlik Enterprise Manager Help
My second objective will be fetching insert count, update count, delete count from a task for the table per day.
How can I achieve above? as I do not see any option to get as desired.
Any assistance is appreciated.
>> However, when I am trying to get list of tables for the specific task, I have defined schema and table in the Api call.
You are using the "get_table_list" api here right? You should NOT provide a schema nor table to get the full list.
>> My objective is to get the schema and table from the task. Defining them just doesn't feel right to me.
Correct, it isn't right. The optional schema and tables parameters are textual FILTERS option to only return the list of schemas/tables which match that files. Do NOT provide to get all.
>> My second objective will be fetching insert count, update count, delete count from a task for the table per day.
You'll be looking at the "get_table_statuses" API for this, again optionally using a schema/table filter. However, the returned counts are since the start of the task. So your tool will have to record the daily values and determine the daily increments, being ready for a task restart (which you can 'see' in the API's)
You probably should look at the Enterprise Manager Analytics options to truly handle your objectives.
Hein.
Hello @dineshkumarl
Try using exportall API but it will display everything including Server details.
Regards,
Suresh
Hello Team,
If our response has been helpful, please consider clicking "Accept as Solution". This will assist other users in easily finding the answer.
Regards,
Sushil Kumar
>> However, when I am trying to get list of tables for the specific task, I have defined schema and table in the Api call.
You are using the "get_table_list" api here right? You should NOT provide a schema nor table to get the full list.
>> My objective is to get the schema and table from the task. Defining them just doesn't feel right to me.
Correct, it isn't right. The optional schema and tables parameters are textual FILTERS option to only return the list of schemas/tables which match that files. Do NOT provide to get all.
>> My second objective will be fetching insert count, update count, delete count from a task for the table per day.
You'll be looking at the "get_table_statuses" API for this, again optionally using a schema/table filter. However, the returned counts are since the start of the task. So your tool will have to record the daily values and determine the daily increments, being ready for a task restart (which you can 'see' in the API's)
You probably should look at the Enterprise Manager Analytics options to truly handle your objectives.
Hein.
@sureshkumar >> Try using exportall API but it will display everything including Server details.
Noop!
This will NOT do any good for the stated objectives.
Export all will only have the requested table list, not the actual table list
Export all will NOT have any statistics.
Hein.
Hi Hein,
Thank you for the information. I was able to proceed further and fetch the table list for my task.