I am trying to upload an excel workbook to a repository called, Documentum. I have never used the PROC HTTP command before.
I do have access to the url due to my being able to use Python to perform this very task.
I am getting the following error: HTTP/1.1 400 Bad Request.
Once I resolve this, I will be using a different authentication scheme.
Here is the sas code running from the Unix environment:
filename reqst "/home/sasuser/XXXXX/phttp/reqst.txt";
filename resp "/home/sasuser/XXXXX/phttp/resp.txt";
filename hdrout "/home/sasuser/XXXXX/phttp/hdrout.txt";
filename hdrin "/home/sasuser/XXXXX/phttp/hdrin.txt";
filename datfile "/home/sasuser/nbkqyyn/phttp/XXXPRD034XXXXX.xlsx";
Proc HTTP
WEBUSERNAME="userID"
WEBPASSWORD="password"
AUTH_BASIC
url="https://baseXXX/dctm-rest/repositories/ECMSGCB/folders/FOLDERIDXXX/documents/"
method="POST"
in=datfile
out=resp
headerin=hdrin
headerout=hdrout
/* CT="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; */
CT="application/vnd.emc.documentum+json";
/* headers "Accept"="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";*/
DEBUG LEVEL=2 ;
run;
%put &=sys_prochttp_status_code.;
%put &=sys_prochttp_status_phrase.;
filename hdrin clear;
filename reqst clear;
filename resp clear;
filename hdrout clear;
filename datfile clear;
Here are the contents of the hdrin.txt file:
object_name: XXXPRD034XXXXX.xlsx
r_object_type:ecap_trad_documents
CT:application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Here are the contents of the hdrout.txt file:
HTTP/1.1 400 Bad Request
Date: Fri, 15 May 2020 16:17:24 GMT
X-Powered-By: Servlet/3.0
X-Content-Type-Options: nosniff
X-XSS-Protection: 1; mode=block
Cache-Control: no-cache, no-store, max-age=0, must-revalidate
Pragma: no-cache
Expires: 0
X-Frame-Options: DENY
X-Cnection: close
Transfer-Encoding: chunked
Content-Type: application/vnd.emc.documentum+json;charset=UTF-8
Content-Language: en-US
Strict-Transport-Security: max-age=31536000
Here are the contents of the resp.txt file:
{"status":400,"code":"E_INPUT_MESSAGE_NOT_READABLE","message":"The input message is not readable.","details":"Error in parsing the JSON into object class: class com.emc.documentum.rest.model.DocumentObject;Unrecognized token 'PK\u0003\u0004\u0014\u0000\u0006\u0000\b\u0000\u0000\u0000': was expecting ('true', 'false' or 'null')\n at [Source: (PushbackInputStream); line: 1, column: 14]","id":"1d9b6f0e-7682-4c94-891b-345395de0dde"}
Thoughts? Thanks!
... View more