You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Trying to use more than 1 delimiter in SOAP Object Queries/Report XML's

Accepted answer
7
Views
1
Comments
edited Aug 15, 2020 12:46PM in Integrations and APIs 1 comment

Summary

Hi, I am looking forward to see if there is a way to use more than 1 delimiter in a SOAP Object Queries/Report XML's request.

Content

I am using the below sample SOAP request to get Incident-related details.

Request:

 <ns7:QueryCSV xmlns:ns7="urn:messages.ws.rightnow.com/v1_4">
            <ns7:Query>SELECT id,Incident.ReferenceNumber FROM Incident where id=5</ns7:Query>
            <ns7:PageSize>10000</ns7:PageSize>
            <ns7:Delimiter>#</ns7:Delimiter>
</ns7:QueryCSV>

 

Response:

 <n0:CSVTable>
                  <n0:Name>Incident</n0:Name>
                  <n0:Columns>ID#ReferenceNumber</n0:Columns>
                  <n0:Rows>
                     <n0:Row>5#170601-000001</n0:Row>
                  </n0:Rows>
     </n0:CSVTable>

 

In few cases, the query will have free text fields like comments, etc, single delimiter is not enough to separate columns in this case. Hence, I am trying for other options like below:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!