I have a table with column Sku, Manufacturer:
001,null
002,null
003,null
002,null
002,null
I want to pass the unique values of Sku to a rest service:
http://api.example.com/v1/products(sku in(001,002,003))?show=sku,manufacturer&format=json
and update the table field with the response from the service:
{"from": 1,
"to": 6,
"total": 6,
"currentPage": 1,
"totalPages": 1,
"queryTime": "0.006",
"totalTime": "0.030",
"partial": false,
"canonicalUrl": "/v1/products(sku in(001,002,003))?show=sku,manufacturer&format=json",
"products": [
{"sku": 001,
"manufacturer": "A"},
{"sku": 002,
"manufacturer": "B"},
{"sku": 003,
"manufacturer": "C"}]}
What are the steps to do this? I’m new to Servoy, details please