Its my first SOAP ingestion.
The XML looks like this
<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<soap:Body>
<ListPublishedFilesResponse xmlns="http://something-something.com">
<ListPublishedFilesResult>
<idbdata xmlns="">
<originator>
<company name="ABC Corp" url="http://www.abc.corp" />
<contact name="ABC Corp" email="post@abc.corp" />
</originator>
<generation date="2024-12-09 10:43:09" dateutc="2024-12-09 09:43:09" />
<contract origin="tendsign.com" tendsigncontractid="2649113" name="Protocol" referencename="1 (ABC-01)" startdate="2018-07-01 00:00:00" startdateutc="2018-06-30 22:00:00" enddate="2025-06-30 00:00:00" enddateutc="2025-06-29 22:00:00" objecttypeid="3">
<attachments>
<file id="15">
<name>ABC123 - Contract</name>
<filename>ABC123-Contract.pdf</filename>
<fileurl>https://contract.abc.com/abc.pdf</fileurl>
<description>Contract</description>
<updated>2024-02-15 14:32:02</updated>
<updatedutc>2024-02-15 13:32:02</updatedutc>
<size>970058</size>
</file>
<file id="15">
<name>ABC123 - Man hours</name>
<filename>Manhours.pdf</filename>
<fileurl>https://contract.abc.com/manhours.pdf</fileurl>
<description>Manhours</description>
<updated>2024-02-15 14:32:14</updated>
<updatedutc>2024-02-15 13:32:14</updatedutc>
<size>505295</size>
</file>
</attachments>
</contract>
</idbdata>
</ListPublishedFilesResult>
</ListPublishedFilesResponse>
</soap:Body>
</soap:Envelope>I am trying to ingest whats between <attachments></attachments>
For this i have looked at this post:
I came up with this:
<api:script xmlns:api="http://apiscript.com/ns?v1" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<!-- See Column Definitions to specify column behavior and use XPaths to extract column values from XML. -->
<api:info title="2" desc="Generated schema file." xmlns:other="http://apiscript.com/ns?v1">
<!-- You can modify the name, type, and column size here. -->
<attr name="name" xs:type="string" readonly="false" other:xPath="/attachments/file/name" />
<attr name="filename" xs:type="string" readonly="false" other:xPath="/attachments/file/filename" />
<attr name="fileurl" xs:type="string" readonly="false" other:xPath="/attachments/file/fileurl" />
</api:info>
<api:set attr="DataModel" value="DOCUMENT" />
<api:set attr="PushAttributes" value="true" />
<api:set attr="EnablePaging" value="true" />
<api:set attr="Header:Name#" value="SOAPAction"/>
<api:set attr="URI" value="https://your.soap.endpoint.com/getData.asmx" />
<api:set attr="XPath" value="/attachments" />
<api:set attr="method" value="POST"/>
<api:set attr="Header:Name" value="Content-Type" />
<api:set attr="Header:Value" value="text/xml" />
<api:set attr="data">
<?xml version="1.0" encoding="utf-8"?>
<soapenv:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:uen="uen:esws">
<soapenv:Header/>
<soapenv:Body>
<uen:Esws.ListPublihedFiles soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
<pub:SystemUserID>123456</pub:SystemUserID>
<pub:ProjectID>121212</pub:ProjectID>
</uen:Esws.ListPublihedFiles>
</soapenv:Body>
</soapenv:Envelope>
</api:set>
<api:set attr="XPath" value="/Envelope/Body/" />
<!-- The GET method corresponds to SELECT. Here you can override the default processing of the SELECT statement. The results of processing are pushed to the schema's output. See SELECT Execution for more information. -->
<api:script method="GET">
<api:set attr="method" value="GET"/>
<api:call op="xmlproviderGet">
<api:push/>
</api:call>
</api:script>
</api:script>When i try to view table, i get his error
This is how Connection and, JSON and XML setting looks like
