0 Replies Latest reply: Oct 23, 2017 4:25 AM by Aleksandr Shiryaev RSS

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

    Aleksandr Shiryaev

      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"

              }

          ]

      }