Ora.pm

ZeroCool

@sdetweil I have been playing wround with MMM-JsonTable but to no avail. This is where I can download the json api for the app I am trying to add but I am not finding anything that works for this.

sdetweil

@ZeroCool so, I just used the sample from the url you posted for tasks

{
  "milestone_id": 1234,
  "task_type": 1234,
  "creator": 1234,
  "second_id": 10,
  "title": "Cool task title",
  "description": "Here you can tell something about the task.",
  "last_picture": "ora-projects.s3.amazonaws.com/default-15.svg",
  "last_picture_external_url": "ora-projects.s3.amazonaws.com/default-15.svg",
  "created_at": "2019-07-31T12:42:49.096305Z",
  "updated_at": "2019-07-31T12:42:49.096305Z",
  "deadline": "2019-09-12T15:22:33.106501Z",
  "archived": true,
  "color": "#473a4f",
  "estimated": "16:33:22",
  "time_tracked": "10:12:33",
  "public": "true",
  "state": "1, 2, 3 or 4",
  "cover_width": 10,
  "cover_height": 10,
  "checklist": "1/10",
  "comments": 20,
  "public_comments": 14,
  "likes": 9,
  "attachments": 6,
  "commits": 3,
  "support_tickets": 1,
  "value": 12,
  "points": 10,
  "points_done": 5,
  "sprint_id": 1234,
  "position": 13
}

one would hope that you get an array(square brackets around) of tasks (I’ve dupped the one entry, and change the title and description fields, and given it an attribute in the returned response) output from jsonvalidator format
https://codebeautify.org/jsonvalidator?/jsonvalidate


{
  "fribble": [
    {
      "milestone_id": 1234,
      "task_type": 1234,
      "creator": 1234,
      "second_id": 10,
      "title": "Cool task title 2",
      "description": "Here you can tell something about the task. again",
      "last_picture": "ora-projects.s3.amazonaws.com/default-15.svg",
      "last_picture_external_url": "ora-projects.s3.amazonaws.com/default-15.svg",
      "created_at": "2019-07-31T12:42:49.096305Z",
      "updated_at": "2019-07-31T12:42:49.096305Z",
      "deadline": "2019-09-12T15:22:33.106501Z",
      "archived": true,
      "color": "#473a4f",
      "estimated": "16:33:22",
      "time_tracked": "10:12:33",
      "public": "true",
      "state": "1, 2, 3 or 4",
      "cover_width": 10,
      "cover_height": 10,
      "checklist": "1/10",
      "comments": 20,
      "public_comments": 14,
      "likes": 9,
      "attachments": 6,
      "commits": 3,
      "support_tickets": 1,
      "value": 12,
      "points": 10,
      "points_done": 5,
      "sprint_id": 1234,
      "position": 13
    },
    {
      "milestone_id": 1234,
      "task_type": 1234,
      "creator": 1234,
      "second_id": 10,
      "title": "Cool task title",
      "description": "Here you can tell something about the task.",
      "last_picture": "ora-projects.s3.amazonaws.com/default-15.svg",
      "last_picture_external_url": "ora-projects.s3.amazonaws.com/default-15.svg",
      "created_at": "2019-07-31T12:42:49.096305Z",
      "updated_at": "2019-07-31T12:42:49.096305Z",
      "deadline": "2019-09-12T15:22:33.106501Z",
      "archived": true,
      "color": "#473a4f",
      "estimated": "16:33:22",
      "time_tracked": "10:12:33",
      "public": "true",
      "state": "1, 2, 3 or 4",
      "cover_width": 10,
      "cover_height": 10,
      "checklist": "1/10",
      "comments": 20,
      "public_comments": 14,
      "likes": 9,
      "attachments": 6,
      "commits": 3,
      "support_tickets": 1,
      "value": 12,
      "points": 10,
      "points_done": 5,
      "sprint_id": 1234,
      "position": 13
    }
  ]
}

so then in JSONTable the

arrayName

property would the “fribble” from above

arrayName:"fribble",

by default it will show EVERY item in each element of the array… not good for large items

so, the

keepColumns

property will allow you select the data items from each ‘record’ u want

keepColumns:[ "title","description","sprint_id","archived"],

you can put nice titles over the columns with the

descriptiveRow

property

its html, in table row/column format

descriptiveRow: '<tr><td>Title</td><td>Description</td><td>Sprint</td><td>is Archived</td></tr>',

so the config would be (using the data above, correct as required from the data you get)

  {
     module: "JsonTable",
    position: ????,
    config: {
       url: "https://api.ora.pm/projects/12345/tasks",
      arrayName:"fribble",
      keepColumns:[ "title","description","sprint_id","archived"],
      descriptiveRow: '<tr><td>Title</td><td>Description</td><td>Sprint</td><td>is Archived</td></tr>',
   }
}

ZeroCool

@sdetweil Thanks for this. I am trying to process it all.

sdetweil

@ZeroCool I just edited my ‘config’ to add a mostly correct tasks url

it needs a real projectID (in place of the 12345)

ZeroCool

@sdetweil I will compensate you for your time if you can help me do this. These things are not in my skillset but I have invested a fair amount of money in a TV and MacMini to make this work in my office. Let me know

sdetweil

@ZeroCool sent u a chat message