Hi evrybody!
Could you help me to find solution how to call REST API where is used MD5 hash as token. In ETL I'v get the list of PROJECT_ID, but I have no idea how to call tasks and subtasks of this projects because there is no function in Qlik sense that made MD5 hash. And if it will then how to put this cycle of calls in ETL.
Here is task description:
Getting the task tree and subtasks in the project : get_tasks
http://abmcloud.worksection.com/api/admin/?action=get_tasks&page=/project/PROJECT_ID/&hash=HASH
hash - verification record, as MD5 formed from three bonded settings page, action and your apikey .
The account owner can get apikey here: http://abmcloud.worksection.com/account/api/
An example of the formation of the verification records for php language: $hash=md5 ($page.$action.$apikey)
Returns the names of the tasks, their statuses (active, done), priority and relative reference to the task
The user_from and user_name fields contain data about the author and the responsible
Date fields:
date_added - date and time of creation
date_closed - date and time of closing
date_start - the date the task was started (if any)
date_end - the specified date of the finish of the task (if any)
The child field (if any) contains a list of subtasks in the same format. Perhaps 2 degrees of nesting: tasks / subtasks / sub-tasks.
JSON response example
{
"status": "ok",
"data": [
{
"name": "TITLE",
"page": "/project/PROJECT_ID/TASK_ID/",
"status": "done",
"priority": "0..10",
"user_from": {
"email": "USER_EMAIL",
"name": "USER_NAME"
},
"user_to": {
"email": "USER_EMAIL",
"name": "USER_NAME"
},
"date_added": "YYYY-MM-DD HH:II",
"date_start": "YYYY-MM-DD",
"date_end": "YYYY-MM-DD",
"date_closed": "YYYY-MM-DD HH:II",
"child": [
{
"name": "SUBTASK_NAME",
"page": "/project/PROJECT_ID/TASK_ID/SUBTASK_ID/",
"status": "done",
"priority": "0..10",
"user_from": {
"email": "USER_EMAIL",
"name": "USER_NAME"
},
"user_to": {
"email": "USER_EMAIL",
"name": "USER_NAME"
},
"date_added": "YYYY-MM-DD HH:II",
"date_start": "YYYY-MM-DD",
"date_end": "YYYY-MM-DD",
"date_closed": "YYYY-MM-DD HH:II"
}
]
},
{
"name": "TASK_NAME",
"page": "/project/PROJECT_ID/TASK_ID/",
"status": "done",
"user_from": {
"email": "USER_EMAIL",
"name": "USER_NAME"
},
"user_to": {
"email": "USER_EMAIL",
"name": "USER_NAME"
},
"date_added": "YYYY-MM-DD HH:II",
"date_closed": "YYYY-MM-DD HH:II"
}
]
}
