Soap xml to table

Questions
1

Hello,
I am a beginner with n8n and I am trying to set up a flow to read from an API and insert into a database.
I can connect to the API (WSDL) and I successfully retrieve the body:, but after I want to change it to table to send it to database. In my example : ns1:exportedEmployeeUserData a table of 4 items EmployeeUserData.
<soap:Envelope xmlns:soap=“``http://schemas.xmlsoap.org/soap/envelope/”``>
<soap:Body>
<ns1:exportEmployeeUserDataListResponse xmlns:ns1=“``http://echange.service.zzz.com``”>
<ns1:exportedEmployeeUserData>
<ns1:EmployeeUserData>
<ns1:employeeKey>1</ns1:employeeKey>
<ns1:employeeSurname>P1</ns1:employeeSurname>
</ns1:EmployeeUserData>
<ns1:EmployeeUserData>
<ns1:employeeKey>2</ns1:employeeKey>
<ns1:employeeSurname>P2</ns1:employeeSurname>
</ns1:EmployeeUserData>
<ns1:EmployeeUserData>
<ns1:employeeKey>3</ns1:employeeKey>
<ns1:employeeSurname>P3</ns1:employeeSurname>
</ns1:EmployeeUserData>
<ns1:EmployeeUserData>
<ns1:employeeKey>4</ns1:employeeKey>
<ns1:employeeSurname>P4</ns1:employeeSurname>
</ns1:EmployeeUserData>
</ns1:exportedEmployeeUserData>
</ns1:exportEmployeeUserDataListResponse>
</soap:Body>
</soap:Envelope>
Can you help me ?
rq : my sample is more easy than in reality, there is a lot of collums :wink:

Tks

2

Hello @Cedric19

You can use the XML to JSOn node to parse the SOAP response,
Once converted to JSON, it’s much easier to reference the fields you need for your database insertion:

image
image444×732 16.7 KB

3

Thanks @mohamed3nan ,

As explain previously my xml is more complexe than the example and when i try to parse with XML to JSON, I’ve an issue. Xml is valid, it’s currently implemented on SSIS ETL :wink:

issue
issue1920×1031 95.4 KB

4

Have you tried playing around with these settings?

image
image462×361 13.1 KB

Maybe something there will fix it.
Honestly, I’m not sure..