URL of JSON to data table

[#1]

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
},...

[#2]

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.

[#3]

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?

[#4]

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.