Need help replacing values in tMap (not conditional statement)

Anonymous — Wed, 06 Nov 2019 00:56:58 GMT

Hi,

This involves JIRA REST API if anyone is familiar, but even without knowledge I think some may be able to help. I don't know if this is the best explanation, but basically I have a tREST call early in my job with an output of "1st JSON response" below. later on in the job I have another tREST call going into a tMap. This tREST call returns only EpicKey, so when this comes into the tMap I want to replace this with it's EpicName value. I can't do if statements because the "1st JSON response" will be hundreds of rows and the values have potential to change. I've tried to play around with tReplacelist and tReplace to no avail, but if this is what I need please let me know and I will try again. If anyone has any advice or options on how to handle this it would be greatly appreciated!

1st JSON response

Column | JSON query

-----------------------------------------------------

EpicKey | "key"

EpicName |"fields.customfield_12222"

tMap desired output

When EpicKey comes in I want to replace with EpicName

Re: Need help replacing values in tMap (not conditional statement)

Anonymous — Sun, 17 Nov 2019 02:43:11 GMT

Hi
Can you show an example of 1st Json response with several rows? Do you use a tExtractJsonField to extract the data from the response? Give us an real response and what are your desired output.

Regards
Shong

topic Re: Need help replacing values in tMap (not conditional statement) in Talend Studio

Need help replacing values in tMap (not conditional statement)

Re: Need help replacing values in tMap (not conditional statement)