New to Talend and would appreciate some help on this issue!
We have built a basic pipeline to fix and standardise values in a few columns in a database. We have an API that we would like to use that can look at the records to be updated, and update this back in the database. This API has been tested outside of Talend and is working.
Any suggestions as to how to integrate the TRESTClient component into this pipeline build? Request and response media type is both JSON, assume some other Talend components will be required to convert/map/parse the data both before and after the TRESTClient component. At the moment the end point of our flow is at a TDBOutput and we're looking to replace this with the TRESTClient component.
I believe you want something like tRESTClient -> tExtractJSONFields -> (your current pipeline without TDBOutput) -> tWriteJSONFields->tRestClient
The first tRESTClient will do the get request to pull the information. Then you extract the JSON into columns, do your standardization, write the new JSON and push it through the API.
