Detect XML attribute xsi:nil and apply null value
I am using a SOAP Execute to retrieve information from an API. The payload is being converted to JSON. The problem is any field that is null returns with an attribute of @xsi:nil:“true”. This is just an example subset. There are actually more than 10 fields returning like this. [ { “ns2:communityCodeDesc”: { “@xmlns:xsi”: “http://www.w3.org/2001/XMLSchema-instance”, “@xsi:nil”: “true” }, “ns2:countyCodeDesc”: { “@xmlns:xsi”: “http://www.w3.org/2001/XMLSchema-instance”, “@xsi:nil”: “true” }, “ns2:dateCreated”: “2023-05-16T11:49:32.010-04:00”, “ns2:dateObsoleted”: { “@xmlns:xsi”: “http://www.w3.org/2001/XMLSchema-instance”, “@xsi:nil”: “true” }, “ns2:familyRSN”: “1250” } ] I need this to be in a more standard JSON form like this… [ { “communityCodeDesc”: null, “countyCodeDesc”: null, “dateCreated”: “2023-05-16T11:49:32.010-04:00”, “dateObsoleted”: null, “familyRSN”: “1250” } ] So I need the xsi: construct converted to null and the namespace identifier dropped. Any help would be appreciated.Solved7.3KViews0likes4CommentsSOAP API Passing credentails to XML envelop
I’m working on an integration with Clarity( Broadcom) - using a soap execute to import data from a Query. In the soap envelope – I need to pass Username and Passoword for authentication . How can I pass credentials securely from account ( basic OAUTH)? It is not taking parameters like account.Username and account.passoword ? <soapenv:Envelope xmlns:obj="http://www.niku.com/xog" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"> <soapenv:Header> <Auth> <Username>account.username</Username> <Password>account.password</Password> </Auth> </soapenv:Header> <soapenv:Body> <Query xmlns="http://www.niku.com/xog/Query"> <Code>test_delete</Code> </Query> </soapenv:Body> </soapenv:Envelope>1.6KViews0likes0CommentsDownloading a base64 zip file using SOAP
Hi All, I am trying to use SOAP call to download a zip file. However, I cannot download and get the file I need correctly. Here is a screenshot of my pipeline. I took out the $content, which contains a string that is (at least looks like) base64 encoded data. The “Content-Type” is null and “Content-Transfer-Encoding” is “binary”. Then no matter how I decode this string, whether by using Base64.decode() or Base64.decodeAsBinary(), I cannot get the zip file I need. If I use Base64.decode($content), I get something like I can see my file name within a bunch of words that I cannot read. And I think I should not use Base64.decodeAsBinary(). Could someone please tell me what is the correct way to download this zip? Thanks in advance!Solved11KViews0likes10CommentsExecuting different SOAP request's based on input field value
Hello, I have to design a pipe line which is based on SOAP request. I have the wsdl. This is my first SOAP pipeline I have few queries. The SOAP Execute snap has three fields Service Name 2) Endpoint . 3) Operation. What values I have to give here, I checked the document but its not clear to me. The wsdl file I have has ‘ExecuteApplication’ endpoint or method. I need to execute this with request payload when the input filed $Action equal to “directory”. I designed a pipe line like this Here Json parser takes the input and Mapper will prepare the payload for SOAP executor. But this pipeline throwing error. “message”: “HTTP Code: 400 Status: POST to pipeline that does not have an unlinked input view Errors: None” Pls suggest how to execute this SOAP request . thanks arun8.7KViews0likes10CommentsPassing Array data into SOAP envelope
Can anyone suggest how I can pass an array of numbers into a SOAP envelope? I need to make a SOAP API call with a list of phone numbers, as in the below example: Using the Customize Envelope editor of SOAP Execute snap I have successfully configured the XML for a single number as: However the idea is to make one SOAP call with many numbers rather than making many calls for one number at a time. I don’t know how I can pass a list of numbers so that it populates the ‘<Number>’ element multiple times. Never done anything extensive with XML so not sure if I need to do something with XML Formatter/XML Generator snaps then merge the content into the Customize Envelope definition? Or create the list as a string then pass it in? Any advice would be greatly appreciated.6.7KViews0likes2CommentsSoap Execute snap is failing
After upgrading to 4.24, we have noticed that SOAP execute snap is failing with the below error : No Buffer space available I changed the SOAP snaplex version to 423patches7441 ; with this its working without any issues. Any idea what could be the issue?1.8KViews0likes0CommentsSOAP Execute has no output
Following the documentation and tutorial (Youtube): https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1437963/SOAP+Execute I am not able to view the output (small green box at the right of SOAP Execute) of the SOAP call. I followed all of the steps precisely. There is no ‘Execute During Preview option’ also (Youtube video is 2018). I have tested all the methods in SOAPUI before beginning integration work with Oracle Peoplesoft. How can I at least get output from the SOAP Execute snap?Solved4.7KViews0likes6CommentsSpecial characters in SOAP Snap
Hi, I am sending the following the Data in the SOAP XML (Chair Rückenlehne mit flexibler 3-D Strickmembran, Kunststoffrahmen aus glasfaserverstärktem Polyamid, Rückenlehne mit Flex-Element,) but it is getting converted to following as this is not in UTF-8 Standard. To convert the data properly at the destination, I need to pass the XML in UTF-8 format. Need help on how to convert the same. Regards, Shreegeet2.8KViews0likes3Comments