Skip to main content

I get data via API in a JSON format. The values from "Points" need to be stored in seperate attributes. I managed to do so with JSON Fragmenter (json["points"]

  • ). With list indexer I can then store each index (0 & 1) to an attribute. But I can not transform then this attribute with DateTimeConverter.  

    In the log I saw, that the list structure still exists in my dataset. I also found this information in the Feature Information (see screenshot).

     

    How can I actually transform the list into a proper attribute?

     

    JSON Structure:

    {

      ...

      "name" : "xy",

      "modified" : "2022-02-16T10:16:53.066Z",

      "points" : n

        1642633200000, 123.99 ],

     

    String replacer Output vs. Feature Information:

    image

  • Hi @hodelc​ , looks like the datetime value e.g. "1642633200000" is an elapsed time from the epoch in milliseconds. I think the DataTimeComverter could recognize it as a valid datetime value from epoch if you converted it to the value in seconds.

    datetime = datetime / 1000 


    Hi @Takashi Iijima​ 

    Thanks, this solved my problem! I did the calculation with ExpressionEvaluator_Output


    Reply