Six Stars

JSON API not getting all rows from the source to excel

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?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Six Stars

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

Hi,

 

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

7 REPLIES
Twelve Stars

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

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?

 

 

 

 

-----------
Six Stars

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

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

 

Twelve Stars

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


@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 Smiley Happy

 


@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

-----------
Six Stars

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

Hi vapukov,

 

 I'm using JSON path

Twelve Stars

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

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 Smiley Happy

- 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

-----------
Six Stars

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

Hi,

 

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

Twelve Stars

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


@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 Smiley Happy

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.


format.PNGror.PNG

 

kudos would be from me ;-)

-----------