• Recent
  • Tags
  • Unsolved
  • Solved
  • MagicMirror² Repository
  • Documentation
  • 3rd-Party-Modules
  • Donate
  • Discord
  • Register
  • Login
MagicMirror Forum
  • Recent
  • Tags
  • Unsolved
  • Solved
  • MagicMirror² Repository
  • Documentation
  • 3rd-Party-Modules
  • Donate
  • Discord
  • Register
  • Login
A New Chapter for MagicMirror: The Community Takes the Lead
Read the statement by Michael Teeuw here.

Ora.pm

Scheduled Pinned Locked Moved Unsolved Requests
11 Posts 2 Posters 1.9k Views 2 Watching
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • Z Offline
    ZeroCool @sdetweil
    last edited by Nov 19, 2022, 2:14 PM

    @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.

    S 1 Reply Last reply Nov 19, 2022, 2:40 PM Reply Quote 0
    • S Offline
      sdetweil @ZeroCool
      last edited by sdetweil Nov 24, 2022, 1:47 AM Nov 19, 2022, 2:40 PM

      @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>',
         }
      }
      

      Sam

      How to add modules

      learning how to use browser developers window for css changes

      Z 1 Reply Last reply Nov 24, 2022, 1:23 AM Reply Quote 0
      • Z Offline
        ZeroCool @sdetweil
        last edited by Nov 24, 2022, 1:23 AM

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

        S 1 Reply Last reply Nov 24, 2022, 1:48 AM Reply Quote 0
        • S Offline
          sdetweil @ZeroCool
          last edited by Nov 24, 2022, 1:48 AM

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

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

          Sam

          How to add modules

          learning how to use browser developers window for css changes

          Z 1 Reply Last reply Nov 27, 2022, 10:34 PM Reply Quote 0
          • Z Offline
            ZeroCool @sdetweil
            last edited by Nov 27, 2022, 10:34 PM

            @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

            S 1 Reply Last reply Nov 27, 2022, 11:42 PM Reply Quote 0
            • S Offline
              sdetweil @ZeroCool
              last edited by Nov 27, 2022, 11:42 PM

              @ZeroCool sent u a chat message

              Sam

              How to add modules

              learning how to use browser developers window for css changes

              1 Reply Last reply Reply Quote 0
              • 1
              • 2
              • 1 / 2
              1 / 2
              • First post
                10/11
                Last post
              Enjoying MagicMirror? Please consider a donation!
              MagicMirror created by Michael Teeuw.
              Forum managed by Sam, technical setup by Karsten.
              This forum is using NodeBB as its core | Contributors
              Contact | Privacy Policy