Acquiring data dynamically from a REST webservice

[EranRaz]

Hi, 

The webservice expecting a JSON with parameters in the body

But I need the body to be dynamically changed according to the user selection, 

something like the pic attached  (the connector works when the  body is hardcoded)

will appreciate any help or guidance on that

thanks

Eran

[stevedark]

Hi @EranRaz 

Unfortunately your images don't seem to have come through.

@chrisbrain's solution of escaping double quotes by doubling them up looks like it will fix a number of your woes.

With regards to the connection, you will need to have a connection that is successfully created. Your best bet may be to create a connection which points to a dummy location (such as https://jsonplaceholder.typicode.com/posts) so that it exists correctly. You can then connect to that at the start of the script.

To insert the correct endpoint you can use another entry in the WITH CONNECTION section to point the URL to the correct place.

Anything you set using WITH CONNECTION will override anything that is in the connection previously.

Hope that helps.

Steve