topic Re: JSON API not getting all rows from the source to excel in Talend Studio

JSON API not getting all rows from the source to excel

Anonymous — Tue, 05 Jun 2018 06:49:08 GMT

Hi, would like to ask if someone here encounter this problem, I have here my job for the extracting the data from API. For the first trest client until to java row its only requesting an access token to be pass on the second trest client, then it will extract the data to excel. My question here is there is no error, but Its only returning the header not the data, but if I change my filter it gives me the header plus the right data. is there any way to determine why is not giving all the data counts from API to excel?

Re: JSON API not getting all rows from the source to excel

vapukov — Tue, 05 Jun 2018 11:19:12 GMT

Hi

from this picture - not possible to give any solutions unless You not provide full information, at least:

- what JSON format?
- what path are You use for extract data?

- what defined as Loop?

Re: JSON API not getting all rows from the source to excel

Anonymous — Wed, 06 Jun 2018 03:48:00 GMT

Hi vapukov,

regarding JSON data format this is the sample (see attached image) and defined the loop into the data row .. about the path sorry but can't provide you due to data security .. anyway, I'm curios because I also have the same sets of palette and their it's working fine, also on the other parameters using the same path of extraction (url of the API), I get the whole data, but some of the parameters can't return the whole value from the API.

Thanks

format.PNG

Re: JSON API not getting all rows from the source to excel

vapukov — Wed, 06 Jun 2018 03:52:37 GMT

@MiHO wrote:

Hi vapukov,

.. about the path sorry but can't provide you due to data security ..

in this case due Your data security - it is not possible to give You any advices

@MiHO wrote:

using the same path of extraction (url of the API),

we are talking about - JSONPath (or XPath) depending from which are You use

Re: JSON API not getting all rows from the source to excel

Anonymous — Wed, 06 Jun 2018 04:23:18 GMT

Hi vapukov,

I'm using JSON path

Re: JSON API not getting all rows from the source to excel

vapukov — Wed, 06 Jun 2018 05:27:26 GMT

tell me please:

I do some work for my finance department, and result of calculation for some accounts is wrong
unfortunately I can not say You - what calculation I do ... but please, tell me - what I do wrong?

this is what You asking from us

- no examples of data

- no examples of error

- no settings of Your Job

what answer You are expect?

nothing personal, but if You need help, it is You must provide full data which allow to help You

Re: JSON API not getting all rows from the source to excel

Anonymous — Wed, 13 Jun 2018 07:10:53 GMT

Hi,

This is already resolved, try to check your header in trestclient, for me I change it from Authorization to X-Client Authorization.

Re: JSON API not getting all rows from the source to excel

vapukov — Wed, 13 Jun 2018 07:16:42 GMT

@MiHO wrote:

Hi,

This is already resolved, try to check your header in trestclient, for me I change it from Authorization to X-Client Authorization.

h-m-m

it is good of course, but if You show for me - where on any from 2 of Your pictures:

This is already resolved, try to check your header in trestclient, for me I change it from Authorization to X-Client Authorization.

kudos would be from me 😉