Using context variables in tFileInputJson Mapping

[Konstantin_Lisyanskiy]

Hello people! Please, help me.

I have two identical jobs which use the tFileInputJson component. One job uses strings in the Json query (Mapping section). Like "[0]", "[1]", etc.

The other job uses context variables that I load from an Excel file. So the mapping looks like context.n_order_id, context.n_order_nbr, etc.

This is the only distinction between the two jobs.

Now, when I run the first one (with constant strings as Json query in the Mapping section), I get the JSON file parsed correctly and exported to a csv file. When I run the second job, I get a file full of empty records.

So, what I am doing wrong?

Thanks in advance!

[houssem_B]

check if your context variables get values from the excel file

[Konstantin_Lisyanskiy]

Well, they do. I used TLogView to check.