Dotliquid JSON Transformation using JSON.net

Question

Im interested in performing JSON transformations and looked into using dotliquid.

In order to avoid having a POCO for the input JSON just to be able to send it as a variable, I would like to send the deserialised JSON. From my understanding, we can't send dynamic to render method, and JObject or JArray does not work as expected. I Tried deserialising to Dictionary< string, object>, but that could not handle nested JSON structures.

liquid

[
{%- for p in data.names -%}
{
"name" : {{ p.name }}
} {%- unless forloop.Last == true -%},{% endunless %}         
{%- endfor -%}
]

C# code

Template template = Template.Parse(File.ReadAllText("Maps/account.liquid"));             
var json = JsonConvert.DeserializeObject<Dictionary<string, object>>(
    @"{ ""names"":[{""name"": ""John""},{""name"":""Doe""}]  }");              

var jsonHash = Hash.FromAnonymousObject(new { Data = json});

Output

[
  {
    "name" : 
  },         
  {
    "name" :  
  }         
]

I know that Microsoft Logic Apps has implemented a similar feature using dotliquid. https://learn.microsoft.com/en-us/azure/logic-apps/logic-apps-enterprise-integration-liquid-transform

What different ways are there? Do I need to parse the JObject/JArray to a nested Dictionary, or what alternatives are there?

Hi Frederik, I'm on the same issue A.T.M. Tried the logic apps, its way too expensive with the use of that integration account. I tried several libraties, DotLiquid, Liquid.NET and i'm still investigating how to convert a json string to a liquid hash to render my data in another json format. I will keep you updated on my findings... Or do you already have a solution? — Ferry Jongmans
– Ferry Jongmans, Commented Mar 25, 2019 at 9:05
Hi, I went with the dictionary<string, object> solution, similar to what's suggested in the accepted answer. Something similar to the second answer to that question. Nevertheless, curious how they have implemented it in Logic Apps, seeing as they use dotliquid — Fredrik Jacobson
– Fredrik Jacobson, Commented Mar 26, 2019 at 12:44

Spo1ler · Accepted Answer · 2019-03-25 18:18:25Z

7

You can get it to work using the DictionaryConverter from Deserialize JSON recursively to IDictionary<string,object> and Hash.FromDictionary

var json = JsonConvert.DeserializeObject<IDictionary<string, object>>(@"{ ""names"":[{""name"": ""John""},{""name"":""Doe""}]  }", new DictionaryConverter());
var jsonHash = Hash.FromDictionary(json);
var templatetest = "<h1>{{device}}</h1><h2>{{speed}}</h2>{% for client in names %}<h4>{{client.name}}</h4>{% endfor %}";

var template = Template.Parse(templatetest);
var render = template.Render(jsonHash);

edited Mar 25, 2019 at 18:18

Spo1ler

4,4441 gold badge26 silver badges34 bronze badges

answered Mar 25, 2019 at 15:48

Sixx

1301 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Maulik Modi Over a year ago

Worked with the same. I am not able to find DictionaryConverter class . also when I do parsing. I get blank array

Krzysztof Madej Over a year ago

@MaulikModi you have DictionaryConverter class in referenced link

Codebricks Over a year ago

Thanks for this - after adding the Dictionary Converter DotLiquid now works like a dream!

DLeh · Accepted Answer · 2023-06-23 17:41:52Z

0

Another option that might work is to use the ExpandoObject converter:

var jsonObj = JsonConvert.DeserializeObject<ExpandoObject>(json, new Newtonsoft.Json.Converters.ExpandoObjectConverter());

This worked in my use case, but we have a wrapper around the Template that expands usability to accept other types, and it might be that that is handling the dynamic nicely.

answered Jun 23, 2023 at 17:41

DLeh

24.6k17 gold badges96 silver badges141 bronze badges

Collectives™ on Stack Overflow

Dotliquid JSON Transformation using JSON.net

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related