HTTP Request doesn't authenticate with NTLM/LDAP directly. You'd want to use something like Passport http://www.passportjs.org/ in your webservice, then use form-based authentication or basic authentication  over https. -Bryan ... View more

request = New HTTP Request( URL("google.com"), Method("GET"), ); request << Send("blob"); headers = request << Get Response Headers(); utc = headers["date"]; tz = round((today() - utc)/inhours(1)); show(tz);   This should be the complete script. ... View more

This might be a little better, so it won't miss the boundaries utc = headers[ "date" ]; tz = Date Difference (utc, today (), "hour" ); show (tz); ... View more

BTW... you can use any url. Routers/switches use UTC time. ... View more

And don't forget you can create JSON by just concatenating strings in the JSON format. No Lists or Associative Arrays needed. ... View more

If I rewrite it like this using the chrome add in JSON Editor, I see a List of Associative Arrays   [ { "month": 1, "month_name": "Jan", "albedo": 0.2, "soiling_loss": 2 }, { "month": 2, "month_name": "Feb", "albedo": 0.2, "soiling_loss": 2 }, { "month": 3, "month_name": "Mar", "albedo": 0.2, "soiling_loss": 2 }, { "month": 4, "month_name": "Apr", "albedo": 0.2, "soiling_loss": 2 }, { "month": 5, "month_name": "May", "albedo": 0.2, "soiling_loss": 2 }, { "month": 6, "month_name": "Jun", "albedo": 0.2, "soiling_loss": 2 }, { "month": 7, "month_name": "Jul", "albedo": 0.2, "soiling_loss": 2 }, { "month": 8, "month_name": "Aug", "albedo": 0.2, "soiling_loss": 2 }, { "month": 9, "month_name": "Sep", "albedo": 0.2, "soiling_loss": 2 }, { "month": 10, "month_name": "Oct", "albedo": 0.2, "soiling_loss": 2 }, { "month": 11, "month_name": "Nov", "albedo": 0.2, "soiling_loss": 2 }, { "month": 12, "month_name": "Dec", "albedo": 0.2, "soiling_loss": 2 } ]   ... View more

Ah. I had a transcribing error going from picture to text.   ... View more

Do you have the link to the API. I don't think you've listed valid JSON. At least the JSON Editor in Chrome doesn't think so. Thanks ... View more

You can build "dynamic" JSON but you'd have to add your sub-elements to the associative array after they have been created. That's just the way JSL works. This shows what I mean: aa = [=>]; list = {}; aa["a jsl list"] = list; Insert Into(list, "Hello World"); Insert Into(list, 2019); show(list); show(aa); outputs: list = {"Hello World", 2019}; aa = ["a jsl list" => {}]; While this: aa = [=>]; list = {}; Insert Into(list, "Hello World"); Insert Into(list, 2019); aa["a jsl list"] = list; show(list); show(aa); Outputs: list = {"Hello World", 2019}; aa = ["a jsl list" => {"Hello World", 2019}]; ... View more

One last thing (or 2).  can the Job Number, etc be passed as a query string parameter (or even JSON can be embedded in the request header) and 2, be sure to add the get with a "body" to the wish list.  That way we can keep track and you can be notified when it's there. Thanks. -Bryan ... View more

After reading up on the HTTP Spec, I see that sending data with a GET is discouraged and that servers usually ignore it. I found this discussion on stackoverflow, which links to the relevant HTTP specs. Is this statement correct? HTTP GET method always has no message body   It basically boils do to some custom webservice implementations might use it and the spec is pretty nebulous about it.  Maybe I can get something in for JMP 15 if the need still exists.   Are there any other avenues to interact with this serviece?   ... View more

Is the JSON embedded in a request header? (Dropbox, Onedrive, and many others do that) The JSON argument in the HTTP Request used in a POST/PATCH/PUT where the content is sent with the JSON content type.  It is a "submit" action. GET are "read" and arguments are either query strings or embeded in a request header. ... View more

"GET" and "POST" are two different HTTP request methods (https://developer.mozilla.org/en-US/docs/Web/HTTP/Methods) "GET" typically reads data from a server while "Post" typically submits data to a server. These are Web Server/Web Service defined outside of JMP/JSL In your first example, you are "POST"-ing (aka submitting) data to "http://fc8tdbitmapconvs07:11111/daas/" and telling the service that ctfn is the JSON content to use. In Attempt#1, the goal is "GET"-ting the status of a running job. I'm not sure what the service is, but if the endpoint is "http://fc8tdbitmapconvs07:11111/daas/status/", then you'd want something like: request2 = New HTTP Request( url( "http://fc8tdbitmapconvs07:11111/daas/status/" ), Method( "GET" ) ); data2 = request2 << Send; Since you wouldn't be submitting anything to the server in a GET. Additionaly, "Content-Type:application/json" is used to describe the content you are sending (not really appropriate in a GET since you are recieving data and probably ignored by the web server) Content-Type: headers are what you are sending (these are automatically set by HTTP Request) Accept: headers are what you tell the web server you'd like. request << Get MIME Type will tell you what the web server sent. (most web servers set this, but it can be empty)   Keep in mind, too that after any request << Send You can do request << Get Status; //this is the http status code request << Get Status Message; //this is the message from the server to investigate any error message the Web Service emits. HTH ... View more

@uday_guntupalli That's a great usage for having HTTP Request << Send accept, say, "blob" or "text" arguments. We'll look into it for JMP 15.  Do you want to add it as a Wish List item? Thanks -Bryan ... View more

You can still use Download instead of Send. What the above shows is that you have gotten a complete download from your web service. (which is good) to use Download instead of Send, you can do this: filename = request << Download("$temp/Test1.xlsx", "replace"); //file is the filename returned by the web server. replace will replace it. if( !IsEmpty(filename), //a filename is empty if the download fails //process your file ); In your case, the mimetype is "text/html" and not an excel spreadsheet. You just named it with and xlsx extension. If your web service has a different endpoint for excel spreadsheets, use that. or If your web service uses and "Accept" header to specify an excel spreadsheet, use that otherwise Open the file with a text editor to see what it is. (or a browser) According to the mimetype, you downloaded html. ... View more

What you have in your code is that Request is the result of Send. I *think* what you want is: request = New Http Request( URL( URLDes), Method("GET"), Headers({HeaderStr}) ); //request is the request object data = request << Send(); //data is the data returned by the web server That way you can examine the status of request after you've interacted with the service. I generally think about HTTP Request stuff in 3 steps Create Configure Send ... View more