Ok, I am very close to getting this working. If I remove the single quotes around the URL Encoded script= code, it WORKS(See below)! proc http method="GET" url="https://mixpanel.com/api/2.0/jql?script=function%20main()%20%7Breturn%20Events(%7Bfrom_date%3A%20%222018-10-17%22,%20to_date%3A%20%222018-10-19%22%7D)%7D" ct="application/json" headerout=hresult out=json; headers "Authorization" = "Basic &api_secret."; run; The issue was the script = code does NOT need the single quotes(even though the cURL statement shows them). However, this now presents another problem. I need to put the script code into its own file and then call the file. The problem is, when I put the file name as the script= statement(something like script=jscript.js), JQL thinks the jscript.js the actual script code and not a file name. I guess I can set a macro variable to the entire file and then just drop the macro variable in place of the jscript.js filename but that seems a little odd to have to do. Any thoughts on this one? Thanks.
... View more