BookmarkSubscribeRSS Feed
HeidiDT
Quartz | Level 8

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";
 
    method="POST"
    ct="application/json; charset=utf-8"
/* webauthdomain="LinuxAuth"*/
webusername="heididt"
webpassword="{SAS002}66B564224EE630732E6388E0395887EC37DCE27D300D953A"
      ;
run;
5 REPLIES 5
joeFurbee
Community Manager

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.


Join us for SAS Community Trivia
SAS Bowl XXXVIII, SAS Programming: Getting Started
Wednesday, February 14, 2024, at 10 a.m. ET | #SASBowl

AlanC
Barite | Level 11

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? 

https://github.com/savian-net
HeidiDT
Quartz | Level 8

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

AlanC
Barite | Level 11
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.
https://github.com/savian-net
HeidiDT
Quartz | Level 8

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?

sas-innovate-2024.png

📢

ANNOUNCEMENT

The early bird rate has been extended! Register by March 18 for just $695 - $100 off the standard rate.

 

Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events. 

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 1061 views
  • 0 likes
  • 3 in conversation