topic Re: Unable to parse JSON "name" using tExtractJSON in Talend Studio

Unable to parse JSON "name" using tExtractJSON

zalibra — Fri, 31 Aug 2018 15:28:22 GMT

Hi all,

I'm trying to parse the JSON pairs "name" from the below string but none of the combinations I used in tExtractJSON worked (I used both JsonPath and Xpath and nothing works).

{"server_time":1535722727,"pairs":{"eur_usd":{"decimal_places":8,"min_price":0.00000001,"max_price":2.0,"min_amount":0.00000001,"max_amount":1000000.0,"min_total":0.0001,"hidden":0,"fee":0.25},"chf_usd":{"decimal_places":8,"min_price":0.00000001,"max_price":2.0,"min_amount":0.001,"max_amount":1000000000.0,"min_total":0.0001,"hidden":1,"fee":0.25},"jpy_usd":{"decimal_places":8,"min_price":0.00000001,"max_price":2.0,"min_amount":0.001,"max_amount":1000000000.0,"min_total":0.0001,"hidden":1,"fee":0.25}

I'm trying to get just the pairs names: "eur_usd", "chf_usd", "jpy_usd". Any help would be greatly appreciated.

Re: Unable to parse JSON "name" using tExtractJSON

vapukov — Mon, 17 Sep 2018 14:18:28 GMT

-- edited

because You need Keys names, it not possible todo with standard Talend components

but possible with tJava

You can search on forum, but I can try to find example from past project

Re: Unable to parse JSON "name" using tExtractJSON

vapukov — Mon, 17 Sep 2018 15:31:09 GMT

something like:

use tLibrayLoad for - javax.json-api-1.1.2.jar

1st tJavaFlex

import java.util.*;
import javax.json.*;

JSONObject object = new JSONObject(row4.line);
String[] keys = JSONObject.getNames(object);

for (String key : keys)
{
    Object value = object.get(key);
}

globalMap.put("array_size", keys.length);

List keylist = Arrays.asList(keys);
globalMap.put("vk",keylist);

2nd tJavaFlex:

List<String> alist = (List<String>)globalMap.get("vk");

Integer ii = ((Integer)globalMap.get("tLoop_1_CURRENT_ITERATION"))-1;

globalMap.put("jkey",alist.get(ii));

it iterate over pair and put each key name into global variable for use on feature steps

Re: Unable to parse JSON "name" using tExtractJSON

zalibra — Wed, 21 Nov 2018 16:40:19 GMT

Thank you for this; this is great!

Re: Unable to parse JSON "name" using tExtractJSON

JYeola — Mon, 04 Sep 2023 12:57:25 GMT

Hi vapukov,

I have similar question where I need to extract pair_names, values of decimal_places, min_price etc and insert it in the db table, then how do I go about it?