Passing JSON format into datastore

I'm wanting to pass json format file into a CDT and ultimately into data store using the Write to Datastore Smart Service.

What's the function I need to write as per below so that I can make this work ? Can't work out how to get from json into Dictionary or List format which seems to be required ?

  Discussion posts and replies are publicly visible

Parents Reply
  • Currently working on configuring the "Load JSON Document To Database" plugin, and I'm seeking some clarification on specific fields. let's say my format for json is 

    {
        "validation.required": "Oops! This field is required.",
        "signup_button": "Sign up now",
        "welcome_header": "Welcome to Lokalise!"
    }

    and the CDT "FJI_jsonData" holds the following fields id, Key(text), Value(Text) and the document is stored in the pv!jsonData

    Fields:
    1. JSON Document (Document): [Should there be a appropriate expression to parse the json or just the document?]
    2. JSON Path (Text)
    3. JSON Fields Match (Any Type): 
    4. JSON key/Column Name mapping (Any Type)
    5. Columns To Process (Text) 
    6. Table Audit fields (Any Type)
    7. Unique Index Columns (Text)
Children
No Data