Hi, I am trying to do a POST request using the REST node transformation in Data Integration Studio.   I need to pass a body in json format. This is an http post working on PowerShell:     $params = @{ "username"="myusername"; "password"="mypassword"; "site"="cittadini"; "traceId"="23133423429"; "tipo"="richiesta"; "history"="true"; } Invoke-WebRequest -Uri http://localhost:8080/searchDocument/1 -Method POST -Body ($params|ConvertTo-Json) -ContentType "application/json" -OutFile "C:\SAS\TEMP\output.json"     This is how I configured the REST transformation in SAS DI:   HTTP method: POST HTTP request endpoint: http://localhost:8080/searchDocument/1 HTTP content type: applicatio/json HTTP charset: utf-8 Input type: text Input charset: utf-8 Input text:  {             "username": "myusername",             "password": "mypassword",             "site":"cittadini",             "traceId":"23133423429",             "tipo":"richiesta",             "history":"true"            } Output type: file   I got an error in the response when executing the SAS job:   type Exception report message Request processing failed; nested exception is java.lang.IllegalArgumentException: Invalid token character ' ' in token "json charset=utf-8" description The server encountered an internal error that prevented it from fulfilling this request. exception org.springframework.web.util.NestedServletException: Request processing failed; nested exception is java.lang.IllegalArgumentException: Invalid token character ' ' in token "json charset=utf-8" org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:656) org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560) javax.servlet.http.HttpServlet.service(HttpServlet.java:650) javax.servlet.http.HttpServlet.service(HttpServlet.java:731) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) root cause java.lang.IllegalArgumentException: Invalid token character ' ' in token "json charset=utf-8" org.springframework.http.MediaType.checkToken(MediaType.java:282) org.springframework.http.MediaType.<init>(MediaType.java:255) org.springframework.http.MediaType.parseMediaType(MediaType.java:584) org.springframework.http.HttpHeaders.getContentType(HttpHeaders.java:286) org.springframework.web.bind.annotation.support.HandlerMethodInvoker.readWithMessageConverters(HandlerMethodInvoker.java:622) org.springframework.web.bind.annotation.support.HandlerMethodInvoker.resolveRequestBody(HandlerMethodInvoker.java:607) org.springframework.web.bind.annotation.support.HandlerMethodInvoker.resolveHandlerArguments(HandlerMethodInvoker.java:346) org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:171) org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:427) org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:415) org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:788) org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:717) org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644) org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560) javax.servlet.http.HttpServlet.service(HttpServlet.java:650) javax.servlet.http.HttpServlet.service(HttpServlet.java:731) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)   The error message makes me think it is something related to the text body format. How should I format the json body text in the REST transformation to work properly?     ... View more

Hello everyone, I have this system with SAS 9.4 installed. I need to register a library for connection to a Microsoft Sql Server database to use in SAS Data Integration.   The system administrators have created an ODBC System DSN, which is configured to use Sql Server authentication.   I cannot use an ODBC library because the ODBC engine for SAS has not been installed or licensed.    In SAS Management Console I see it is possible to register a database server of type "Microsoft SQL Server" and a library of type "Microsoft SQL Server Library", as shown below        Following the documentation LIBNAME Statement Specifics for Microsoft SQL Server, I've registered a libref using the following command:     libname mssqllib sqlsvr noprompt="uid=MY_USER; pwd=MY_PASSWORD; dsn=MY_DSN_NAME;" stringdates=yes schema=DBO;   Then I am a bit lost. I've tried to create in SMC a database server of type "Microsoft SQL Server" specifying "MY_DSN_NAME" as Datasrc, then I've created a Microsoft SQL Server Library using this server and "mssqllib" as libref, but when I've tried to register some tables on that library I got Sql Server authentication error in the log:   ERROR: CLI error trying to establish connection: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sasadm@saspw' It seems it's using the user logged to the Management Console instead of the user specified in the LIBNAME statement (MY_USER, MY_PASSWORD).   Can someone provides the required steps to properly register a Microsoft SQL Server Library on SAS? In the documentation I've found only the steps to register an ODBC library, but I cannot follow that way since the ODBC engine was not installed/licensed in this SAS installation.   Thanks for any help!     ... View more