Get Count from tRest in Talend
I am using a tRest component to get data from a web service. The tLogRow indicates a count value that I would like to get, but don't know how.
{"result":[my data blabla multiple fields],"count":22}
How can I get the count value ?
I tried a tExtractJSONFields and a tMap, but to no avail
tExtractJSONFields
Thank you in advance, I appreciate the help
Solution
the problem comes from your tExtractJSONFields component the JSON path should point to the previous node you're trying to access (you want the count so in this case is the root of the JSON) and you haven't set the JSON query to retreive the data.
Given the data you've given in your question
{"result":[my data blabla multiple fields],"count":22}
The configuration should be like this :
- Select counts from one table based in the results from another table
- Avoiding overlap in frequency and document frequency count in Quanteda
- Add column count of occurrences
- Get all data COUNT fastest from large table based on condition
- Output a list from a sentence and count characters for each word
- PHP: Count a stdClass object
- Query data and how many rows have that date in mysql
- Count "truthy" values in a 2d array
- Count the number of objects in an array of object with a specified property value
- Count rows of a 2d array which contain a qualifying column value
- Determine if two arrays have at least 3 shared values
- Count the occurrence of one vector's values in another vector
- Counting the number of specific occurrences in a java String
- Expand value_counts() view?
- Looping over Pandas columns while counting rows that contain two specified values
- Count elements in a row and create column counter in pandas
- How to use Count in a Pivot clause
- creating a chart using a count query on repository in symfony
- Why is mongodb collection count deprecated?
- Mysql count vs mysql SELECT, which one is faster?
- How to efficiently count the number of keys/properties of an object in JavaScript
- Pivot and count grouped values of a 2d array to create a new 2d array with zero-defaulted columns
- How can I find the number of unique characters in a string?
- How to apply chi squared test on a series of count tables?
- Count multiple letters in string Python
- Access is multiplying my query count by 38.... why?
- COUNT where SUM condition using DQL
- Return total number of rows found while paging in JAX-RS resource
- Counting all "-1" and -1 in a dataframe for a list of certain columns
- Equivalent of FOUND_ROWS() function in Postgresql