CODEWITHSUNDEEP
node.jsjsonrestnpmjsonata
user3497702
user3497702

Reputation: 851

JSONata - JSON to JSON Transformation in Nodejs API

I need to write REST API in Node jS for JSON to JSON transfromation.

There are many library and I sort listed "JSONata"

Please find JSONata simple sample here

The challenge is API receive JSON which has data and map but JSONata require map value without quotes.

{ "data" : { "title" : "title1", "description": "description1", "blog": "This is a blog.", "date": "11/4/2013" }, "map" : { "name": "title", "info": "description", "data" : { "text": "blog", "date": "date" } } } but the map object expected by JSONata is like below.

{
  "name": title,
  "info": description,
  "some" : {
 "text": blog,
  "date": date
  }

}

The above JSON key is in Quotes and value without Quotes.

Please find the NodeJS API code.

app.post('/JSONTransform', function(req, res, next) 
{
const data = req.body.data;
const map = req.body.map;
var expression = jsonata(map);
var result = expression.evaluate(data);
res.send(result);
});

I can write simple function to remove quotes but the above map is simple example. It can be any no of child object and may have some special character in the value including quotes.

I prefer some npm library or standard way to remove quotes or configure JSONata to accepts quotes in value.

Appreciate if you suggest any other library or option.

This Node JS API is called from ASP.NET Core Web API. ASP.NET Core Web API gets the data and map from database and pass this as single JSON to Node JS API.

Please suggestion solution to this problem or best alternative.

Thanks

Raj

Upvotes: 1

Views: 1882

Answers (1)

user3497702
user3497702

Reputation: 851

I found solution to this problem.

Pass the single JSON that has both data and map. Since MAP is not valid JSON, I made entire map as string and escaped doubles quotes which is inside the string.

Please find the sample.

{
  "map": "{   \"name\": title,   \"info\": description,   \"data\": {      \"text\": blog,      \"date\": date    }}",
  "data": {
    "title": "title1",
    "description": "description1",
    "blog": "This is a blog.",
    "date": "11/4/2013"
  }
}

Upvotes: 1

Related Questions