SAS Support Communities

Steve,   Stepping through your attempts, you are close each time, but have simple mistakes we can easily address:   Attempt 1 When you use the IN= option with a quoted string, that data is posted, literally.  So instead of sending the contents of the JSON file as you probably assume you are, you are actually just sending the web service the literal string "S:\My School QA\2021 Data Collection\SBD_Independents\FTP_Account_Creation\Requests\test1.json".  The web service is expecting JSON data (because you specified the content_type), which this is not, so it responds with "Bad Request"   Instead you want to use the fileref you created when you wrote the json data to a file in the first data step ie: filename json_in temp; ... proc http ... in=json_in /*no quotes*/ ...     Attempt 2 Here you have a similar issue.  You are using the FORM method on the IN= option.  This helper method serializes the data you provide as a content-type such as application/x-www-form-urlencoded which your web service doesn't appear to support.  The bad content type and data is why you receive the "Unprocessable Entity" error   You cannot use the FORM or MULTI helpers here in the IN= option as they are not valid for the type of data you want to POST   Attempt 3 This time the issue is slightly different.  You are correctly trying to use the IN= option with string data equivalent to the JSON you want to post, however, you are using single quotes inside your JSON which is invalid syntax.  You also should be including the CT= option with application/json   Instead, you want to use double quotes inside the JSON string as you have elsewhere in your post here: proc http ... in="{""notify"": true, ""emails"": [""croftie@tpg.co.au""], ""roleId"": 7, ""notifyFileAdded"": false}" ... Attempt 4 This is essentially the same as attempt 1   Attempt 5 This is essentially the same as attempt 3, this is invalid JSON syntax so the web service cannot handle the data it receives.   Additional Information Across all of your attempts you are also leaving out additional headers that could be important to your web service successfully responding to your request.  Here is the most complete translation of your curl command in the HTTP Procedure   proc http method="POST" url="https://pluto.acara.edu.au/rest/folders/100/members" ct="application/json" oauth_bearer="&token" /* equivalent of headers "Authorization"="Bearer &token" */ in="{""notify"": true, ""emails"": [""croftie@tpg.co.au""], ""roleId"": 7, ""notifyFileAdded"": false}"; headers "Accept"="application/json" "X-Accellion-Version"="16"; debug level=3 NO_REQUEST_BODY NO_REQUEST_HEADERS OUTPUT_TEXT; run;   ... View more

See the SASPy API Reference   https://sassoftware.github.io/saspy/api.html#saspy.SASsession.submit   Using %include as Tom suggests would presume that Jupyter, where you said you uploaded the code, is the same machine where you are submitting to SAS.   Two additional options you have:   1. Ditch the .sas file and put it's contents directly into your notebook as such:   results_dict = sas.submit( """ libname tera teradata server=teracop1 user=user pw=pw; proc print data=tera.dsname (obs=10); run; """ ) 2. Read the file contents into Python and then submit:   code = open('/users/myuserid.files/SAS_filename.sas').read() results_dict = sas.submit(code)   ... View more

@SergioSAS,   Below is an example of using the IDataSet interface, however, you may find it simpler to use JDBC instead.   import com.sas.iom.SAS.*; import com.sas.iom.SASIOMDefs.*; import com.sas.services.connection.*; import org.omg.CORBA.IntHolder; import org.omg.CORBA.StringHolder; import java.util.Arrays; public class SasOutputDataExample { public static void main(String... args) { ConnectionInterface cx = null; boolean failed = false; try { BridgeServer server = new BridgeServer(BridgeServer.CLSID_SAS, "sas.myhost.net", 8591); server.setEncryptionContent(BridgeServer.ENCRYPTION_CONTENT_ALL); server.setEncryptionAlgorithms(BridgeServer.ENCRYPTION_ALGORITHM_AES); server.setSecurityPackage(BridgeServer.SECURITY_PACKAGE_NEGOTIATE); server.setSecurityPackageList(BridgeServer.SECURITY_PACKAGE_LIST_DEFAULT); ManualConnectionFactoryConfiguration mconf = new ManualConnectionFactoryConfiguration(server); ConnectionFactoryManager manager = new ConnectionFactoryManager(); ConnectionFactoryInterface factory = manager.getFactory(mconf); SecurityPackageCredential cred = new SecurityPackageCredential(); cx = factory.getConnection(cred); } catch (ConnectionFactoryException err) { System.out.print(err.getMessage()); failed = true; } if (!failed) { IWorkspace workspace = IWorkspaceHelper.narrow(cx.getObject()); try { ILanguageService ls = workspace.LanguageService(); ls.Submit("data kids; set sashelp.class; run;"); ILibref libWork = workspace.DataService().UseLibref("work"); int flags = 0; StringHolder dataSetLabel = new StringHolder(); StringHolder dataSetType = new StringHolder(); DateTimeHolder dateCreated = new DateTimeHolder(); DateTimeHolder dateModified = new DateTimeHolder(); IntHolder recordLength = new IntHolder(); StringHolder compressionRoutine = new StringHolder(); IntHolder bookmarkLength = new IntHolder(); IntHolder logicalRecordCount = new IntHolder(); IntHolder physicalRecordCount = new IntHolder(); IntHolder attrs = new IntHolder(); IDataSet kids = libWork.OpenDataSet(flags, "kids", "", new String[]{"", "", ""}, dataSetLabel, dataSetType, dateCreated, dateModified, recordLength, compressionRoutine, bookmarkLength, logicalRecordCount, physicalRecordCount, attrs); int bindKey = 0; byte[] positionBookmark = new byte[]{}; int numberRowsToRead = 2; int rowsOffset = 0; VariableArray2dOfStringHolder characterValues = new VariableArray2dOfStringHolder(); VariableArray2dOfDoubleHolder numericValues = new VariableArray2dOfDoubleHolder(); VariableArray2dOfOctetHolder missingValues = new VariableArray2dOfOctetHolder(); OctetSeqHolder bookmarks = new OctetSeqHolder(); IntHolder status = new IntHolder(); kids.ReadRecords(flags, bindKey, positionBookmark, numberRowsToRead, rowsOffset, characterValues, numericValues, missingValues, bookmarks, status); for (int i = 0; i < numberRowsToRead; i++) { System.out.println(Arrays.toString(characterValues.value[i])); //character values are formatted } workspace.Close(); cx.close(); } catch (Exception err) { err.printStackTrace(); } } } }   This should then print the following to the console   [Alfred , M, Alfred , M, 14, 69, 112.5] [Alice , F, Alice , F, 13, 56.5, 84]   IDataSet can also provide you with the metadata for the data set (i.e. Column Names, etc...) ... View more