Question

Flexible data modeling - transformation to JsonObject type

  • 21 November 2022
  • 4 replies
  • 56 views

Hi,

 

I have created one FDM model having JsonObject field. In the transformation query I referred that field , example query:

SELECT Series_Title as externalId,
       Series_Title as name,
       Overview as description,
       int(Gross) as gross,
       float(IMDB_Rating) as imdbRating,
       int(Runtime) as runTime,
       int(Released_Year) as releasedYear,
       '{"key1":"value1","key2":{"key3":12,"key4":"hello","key5":{"key6":10}}}' as data
FROM movies.movies

FDM model is:

type Movie {

  name: String!

  description: String

  watchedIt: Boolean

  imdbRating: Float

  releasedYear: Int

  runTime: Int

  gross: Int

  actors: [Actor]

  data: JSONObject

}

 

 

The transformation is failing with this error:

Unknown property type Json.

 

May be I am missing something, Can you please help?


4 replies

Badge

Hi,

You are not missing anything :)

Currently Transformation does not support writing to Json type yet. We have this feature in the backlog and will work on it.

 

Thanks @Vu Hai Nguyen  for the quick response. I have follow up question on using TimeSeries Type in FDM data model. Is it the native CDF timeseries resource type. Can we link FDM field to existing timeseries resource type to refer the existing timeseries data. If it is true , How can I use that in transformation, to link the timeseries data.

Badge

Hi,

We made the fix to support Json type can you try it again?
I don’t think we have well support to link timeseries data with FDM yet. But there’s work on it to grow with FDM as well  :)

Userlevel 1
Badge +1

Hi @Niranjan Madhukar Karvekar ,

I'm just following up from my end. Were you able to check whether the Json type worked for you?

Best regards,
Dilini

Reply