topic Re: URL of JSON to data table in Discussions

URL of JSON to data table

bjbreitling — Fri, 15 Nov 2024 20:15:15 GMT

I have an internal URL "https://savrptsdev.XXX" That has JSON data listed below. How woul i import this as a data table with JMP? I have 17 PRO version right now.

JSON Example:

[
{
"containerId": 18078,
"bookingNumber": "231146696",
"scac": "MAEU",
"containerNumber": "MRKU4343819",
"statusName": "Completed",
"daysInDetention": 4,
"checkedOutDate": "2023-10-04T08:58:51.477",
"lastFreeDay": "2023-09-30",
"detentionReason": null,
"detentionReasonByUser": null
},
{
"containerId": 18140,
"bookingNumber": "NAM6432371B",
"scac": "CMDU",
"containerNumber": "GESU6617870",
"statusName": "Completed",
"daysInDetention": 9,
"checkedOutDate": "2023-10-13T06:37:38.84",
"lastFreeDay": "2023-10-04",
"detentionReason": null,
"detentionReasonByUser": null
},...

Re: URL of JSON to data table

jthi — Fri, 15 Nov 2024 20:21:04 GMT

Have you tried using JMP's Open?

Depending on how you are getting your data there are also some other scripting methods you can use.

Re: URL of JSON to data table

bjbreitling — Fri, 15 Nov 2024 20:51:48 GMT

So I went to File>Open and put the URL in but it prompted me for my credentials. Is the interface you show here supposed to pop up in JMP 17.2?

Re: URL of JSON to data table

martindemel — Sat, 16 Nov 2024 02:23:18 GMT

Hi,

there are some existing solutions for similar questions, you may find the one probably already there:

Search Results to open JSON data

Basically if you have a *.json file you can use File-> open. However if you have credentials to be entered, this seems to be a restriction of the data provider (probably your IT restrict the access to employees only who have credentials to access the data). You could use

New HTTP Request()

to specify all auth2 settings and other necessary information. here is a thread where @jthi has answered how to do this.

An older post has been answered by justin chilton which also might be helpful.