Webservice Connector Paging Scirpt: Handle/Escape double quotes(")

Identity Security Cloud (ISC) ISC Discussion and Questions
, , ,
1

:bangbang: Please be sure you’ve read the docs and API specs before asking for help. Also, please be sure you’ve searched the forum for your answer before you create a new topic.

Please consider addressing the following when creating your topic:

  • What have you tried?
    I have a double quotes in the URL and not sure how to handle/escape in the Pagination steps in Webservice connector. I tried " and “”, did not work.
  • What errors did you face (share screenshots)?
    image
    Pagination does not work, navigate the first page URL twice and stops.
  • Share the details of your efforts (code / search query, workflow json etc.)?
  • What is the result you are getting and what were you expecting?
2

Hi @venus ,
Greetings of the daY!

To handle double quotes in the URL in Web Service connector. you can try the below format

Example:https://testing.com/api/items?search=“sample”

as https://testing.com/api/items?search=
%22sample%22

Let me know for any queries .

Thank you
Mahesh M

3

Thanks Mahesh for your reply, not in the URL. I wanted to escape in Paging script where I need to pass a filter which required the value in double quotes.

$endpoint.fullUrl$ = $application.baseUrl$ + “?filter=name eq "Test user"&count=10&startIndex=” + $sysparm_offset$

4

Can you try this?
$endpoint.fullUrl$ = $application.baseUrl$ + “?filter=name eq %22Test%20user%22&count=10&startIndex=” + $sysparm_offset$

5

I tried this and let me try again. Does anyone know if the paging script uses apache Velocity templating or SailPoint proprietary?