tFileInputJSON failed when i changed a value in JSON data

Anonymous — Sat, 16 Nov 2024 04:37:12 GMT

Hi,

I'm having an issue when I try to extract some values from a JSON data reading a file with tFileInputJSON. The problem is that when i changed a value of the JSON data, tFileInputJSON doesn't extract the pk value.

Successfull Case

tFileInputJSON read the file with the JSON

{"pk":"2147422292","marketplace_pk":13,"shop_pk":1083925,"reference":"2147422292"}

The output shows that the value pk is extracted sucessfully.

[statistics] connected
pk
2147422292
[statistics] disconnected

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

Failed Case

tFileInputJSON read the file with the JSON (as you can see I only change the value pk, only that)

{"pk":"2147488276","marketplace_pk":13,"shop_pk":1083925,"reference":"2147422292"}

The output shows that the value of pk wasn't extracted, even when the structure is the same.

[statistics] connected
pk
[statistics] disconnected

For this case I got also the reject output which says

|pk | errorCode | errorMessage |
|=-+---------+---------------------------------------=|
|0 |null |For input string: "2147688276" - Line: 0|
'--+---------+----------------------------------------'

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

I did some test and from 30 different pk values, it only read 7, but I don't know why if is the same data and structure.

Can somebody help me to understand why is happenning this or if I'm doing something wrong?

Best Regards

Re: tFileInputJSON failed when i changed a value in JSON data

TRF — Fri, 20 Sep 2019 07:22:45 GMT

Is your pk field defined as an integer?
In this case, value must be less or equal to 2,147,483,647.

Re: tFileInputJSON failed when i changed a value in JSON data

Anonymous — Mon, 23 Sep 2019 22:50:37 GMT

Hi,

You are correct, I forgot to check that. I change the type from Integer to String and now I get the date from all the PK values.

Thanks!!

topic tFileInputJSON failed when i changed a value in JSON data in Talend Studio

tFileInputJSON failed when i changed a value in JSON data

Re: tFileInputJSON failed when i changed a value in JSON data

Re: tFileInputJSON failed when i changed a value in JSON data