topic Including Binary Content in Proc HTTP POST request in SAS Programming

Including Binary Content in Proc HTTP POST request

kerrmc36 — Tue, 23 May 2023 09:17:57 GMT

I'm trying to perform a rest API POST request to upload an attachment to a Share Point List

I've successfully managed it with Postman via the file link on the Body /Binary tab of PostMan

(with URL https://mysharepointsite/_api/Web/Lists(guid'mylistguid')/items(7406)/AttachmentFiles/ add(FileName='myfile.xlsx')

but I can't work out how to code the binary data part in SAS Proc HTTP

The curl snippet for the binary content is

--data-binary '@/Y:/API_Project/SharePoint/OutPut/myfile.xlsx'

This is my last attempt

proc http
url= "https://mysharepointsite/_api/Web/Lists(guid'mylistguid')/Items(7406)/AttachmentFiles/ add(FileName='myfile.xlsx')"
method = "POST"
OAUTH_BEARER= &token.
IN= '@/Y:/API_Project/SharePoint/OutPut/myfile.xlsx'
headerout = Atthead
HEADEROUT_OVERWRITE
clear_cache;
headers "X-RequestDigest"="&FDV." "Accept"="application/json";
run;

Re: Including Binary Content in Proc HTTP POST request

JosvanderVelden — Tue, 23 May 2023 10:20:47 GMT

Have you seen @ ChrisHemedinger solution in this post: https://communities.sas.com/t5/SAS-Programming/How-to-make-a-PROC-HTTP-Post-request-by-passing-a-JSON-message/td-p/476946
I believe that has an example that will work for you.

Re: Including Binary Content in Proc HTTP POST request

kerrmc36 — Tue, 23 May 2023 11:25:06 GMT

Many thanks for quick reply - I'll try creating a JSON file to read in put I'm still unclear how I should reference the file path in the JSON. What key should I use to reference ?

Re: Including Binary Content in Proc HTTP POST request

ChrisHemedinger — Wed, 24 May 2023 15:11:22 GMT

I have not tried methods to add attachments -- only to upload files into a SharePoint collection. I've got that code in some macros in this GitHub project: https://github.com/sascommunities/sas-microsoft-graph-api/

That method uses the Upload Session API that allows for large files. It seems like this attachment approach is different, but maybe you can glean some hints from it.