Skip to main content
Question

How to read json

  • April 2, 2023
  • 1 reply
  • 6 views

checcosisani
Contributor
Forum|alt.badge.img+12

Hi

I need to extract from json the info reated to each run

 

"Name": "Run 1",

"Start Time UTC": "",

"Stop Time UTC": "",

"Duration (hh:mm:ss)": "",

 

I tried to use the json transformer but no success

 

thx for help

 

Francesco

1 reply

redgeographics
Celebrity
Forum|alt.badge.img+59
  • Celebrity
  • 3700 replies
  • April 3, 2023

You need to tell the JSON reader what (and how) to read:

 

In its parameters, set the Schema Scan mode to "JSON Query" and specify a JSON Query to read:

Schermafbeelding 2023-04-03 103206