topic SAS Data Remediation REST API in Developers

SAS Data Remediation REST API

HeidiDT — Thu, 17 Aug 2023 11:50:59 GMT

Hi All

I am trying to POST issues to Data Remediation using the REST API, but keep getting 500 Internal Server Error. I am just trying with one issue at the moment just to get the logging sorted out, and then I will start looking at logging multiple issues. Here is my SAS Enterprise Guide code and I have attached the input file. Please could you assist if possible?

filename in "/sas/batch/sasdata/dataremediation/tables/json_manual.txt";

filename out "/sas/batch/sasdata/dataremediation/tables/json_out.txt";

proc http in=in out=out url="https://server:port/SASDataRemediation/rest/groups"

method="POST"

ct="application/json; charset=utf-8"

/* webauthdomain="LinuxAuth"*/

webusername="heididt"

webpassword="{SAS002}66B564224EE630732E6388E0395887EC37DCE27D300D953A"

;

run;

Re: SAS Data Remediation REST API

joeFurbee — Thu, 17 Aug 2023 17:01:03 GMT

Hi @HeidiDT,

I've not worked with the Data Remediation APIs before, so it may take me a bit of time to gather resources to assist.

Unfortunately a 500 error doesn't give us much to go on. Can you try a 'GET' method on the same groups endpoint? Establishing a connection is the first step before we can troubleshoot further.

Re: SAS Data Remediation REST API

AlanC — Thu, 17 Aug 2023 17:33:09 GMT

Joe sounds like he has this covered. I wanted to add that you should always get the API working with Postman SoapUI, or other web testing tool before tackling the SAS code. Have you done that already?

Re: SAS Data Remediation REST API

HeidiDT — Fri, 18 Aug 2023 10:29:52 GMT

Hi @AlanC. I have tried with Postman and am getting the same error unfortunately.

Re: SAS Data Remediation REST API

AlanC — Fri, 18 Aug 2023 14:07:12 GMT

Dig down into the error as much as possible. When I get into this area, I turn on Fiddler and check the traffic flow. Postman probably gives you something similar but you can use Fiddler with Postman as well. You have to look at the raw request and response going and coming.

Re: SAS Data Remediation REST API

HeidiDT — Tue, 22 Aug 2023 09:24:46 GMT

Hi All!

So I have managed to get past the 500 error and am now getting a 401 (unauthorized) error. I have been trying to find documentation on the wed regarding authentication when using the SAS provided APIs, but am not having much luck. Can anyone help with authentication for SAS RESTful APIs in general, please?