Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

shiryaev
New Contributor

Connecting to Qlik Sense REST connector to API that use MD5 hash token

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"

        }

    ]

}

 

Community Browser