Configure the path to token field in the HTTP response body

Integrator.io
, , ,
1

I am using XML based SOAP APIs.
For the configure refresh token section I need to put a XML request body to the same base URI as the one in the connection. The request body is:


<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">


******************
************
*********************


And the Response Body is:

<?xml version="1.0" encoding="utf-8"?>



    

        

            ***********************************


For the setting "Path to token field in HTTP response" I am choosing the HTTP response body option:

5301043caa20740200000001-7282dc03b6c948dba0abd3c018ac93c0.png
5301043caa20740200000001-7282dc03b6c948dba0abd3c018ac93c0.png724×294 22.6 KB

But I am not sure how to find out the Path to token field in the HTTP response body.


When I pass the response body above in the Celigo Playground XML parser this is what I get as a JSON response:


[
  {
    "page_of_records": [
      {
        "record": {
          "soap:Body": {
            "AuthenticationTokenGetResponse": {
              "AuthenticationTokenGetResult": "*******************************",
              "xmlns": "http://rex11.com/webmethods/"
            }
          },
          "xmlns:soap": "http://schemas.xmlsoap.org/soap/envelope/",
          "xmlns:xsi": "http://www.w3.org/2001/XMLSchema-instance",
          "xmlns:xsd": "http://www.w3.org/2001/XMLSchema"
        }
      }
    ]
  }
]


Any idea what should be the path to token field here. The path that you see in the screenshot does not seem to work here.

2

@sujitdesai183 I would try something like this:

/*[local-name()='Envelope']/*[local-name()='Body']/*[local-name()='AuthenticationTokenGetResponse']/*[local-name()='AuthenticationTokenGetResult']/text()

This is xpath notation and I usually use a website like http://xpather.com/ to figure out what is needed.

5301043caa20740200000001-38ea6b4b58934812ba4a4027f6eb1f9b.png
5301043caa20740200000001-38ea6b4b58934812ba4a4027f6eb1f9b.png2560×619 181 KB

You could also try a normal path expression like below, but not sure if it will work here.

/soap:Envelope/soap:Body/AuthenticationTokenGetResponse/AuthenticationTokenGetResult
3

@tylerlamparter thanks for the insight. I tried both the suggestions but none of them worked.

4

@sujitdesai are you getting any particular error? Do you have anything in the "how to test connection" section?

5

@tylerlamparter I am getting the invalid authentication string error. I tried to use the path you suggested above in the refresh token settings of my HTTP connection and then using the {{{connection.http.auth.token.token}}} handlebar to provide the authentication string in the request body of the Import Step. I tried doing a test send and actually running the flow. In both the cases it gave me invalid authentication string error.

The only way we can test the connection is by trying to post some test data to some endpoint. While posting the data in the request body we would need to put the token itself. Not sure if we can use the handlebar {{{connection.http.auth.token.token}}} OR {{{connection.http.auth.token.refreshToken}}} in the request body in the 'How to test connection' section.

I would be happy to jump on a call, probably the IO office hours to troubleshoot this issue. Is this something we can do? Send me the link for you calendly or link to book the session if that is possible.

Thanks!

6

@sujitdesai yes feel free to come by office hours next week. https://docs.celigo.com/hc/en-us/articles/360045798291

7

Is this working?