I need to pull data from a rest-api but the data needs to be filtered by a value that I can only get (a table key) by first calling the rest-api to retrieve it. So I need to something like:
get product/search$parentName=SomeValue
(save the parentName's key value from the returned json)
get product/searchChildren$parentKey=SavedKeyFromFirstCall.
Display the child data in the Elements Connect field.
Is this possible, maybe with Velocity, which I don't have experience with?