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.8k 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
      last edited by

      I am trying to display my company’s Ora.pm kanban but know zero Json. Any guidance/advice would be helpful.

      I have some json from the app and an API but thats about the extent of my ability.

      TYIA

      • ZC
      S 1 Reply Last reply Reply Quote 0
      • S Offline
        sdetweil @ZeroCool
        last edited by sdetweil

        @ZeroCool there is a module that will allow you to display a table from json retrieved via API.

        see the 3rd party modules list form MMM-JsonTable

        https://github.com/MichMich/MagicMirror/wiki/3rd-party-modules

        a helpful tool is one of the online json validators, that support formatting. makes viewing the document much more understandable

        this is the one I use, paste your json in here
        https://codebeautify.org/jsonvalidator

        and hit the left button on the gray bar above the text

        Sam

        How to add modules

        learning how to use browser developers window for css changes

        Z 3 Replies Last reply Reply Quote 0
        • Z Offline
          ZeroCool @sdetweil
          last edited by

          @sdetweil I appreciate that but this whole thing is foreign to me

          S 1 Reply Last reply Reply Quote 0
          • S Offline
            sdetweil @ZeroCool
            last edited by

            @ZeroCool i hear you… lots of learning to get what you want

            Sam

            How to add modules

            learning how to use browser developers window for css changes

            1 Reply Last reply Reply Quote 0
            • Z Offline
              ZeroCool @sdetweil
              last edited by

              @sdetweil Thanks. I have tried this and got no where. Appreciate the link regardless

              1 Reply Last reply Reply Quote 0
              • Z Offline
                ZeroCool @sdetweil
                last edited by

                @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 Reply Quote 0
                • S Offline
                  sdetweil @ZeroCool
                  last edited by 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>',
                     }
                  }
                  

                  Sam

                  How to add modules

                  learning how to use browser developers window for css changes

                  Z 1 Reply Last reply Reply Quote 0
                  • Z Offline
                    ZeroCool @sdetweil
                    last edited by

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

                    S 1 Reply Last reply Reply Quote 0
                    • S Offline
                      sdetweil @ZeroCool
                      last edited by

                      @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 Reply Quote 0
                      • Z Offline
                        ZeroCool @sdetweil
                        last edited by

                        @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 Reply Quote 0
                        • 1
                        • 2
                        • 1 / 2
                        • First post
                          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