CODEWITHSUNDEEP
javascriptjsonnode.js
Michael J. Calkins
Michael J. Calkins

Reputation: 32663

Transforming api json responses for NodeJS

I'm ending up having to do hacks to convert 'true' to just true and it's creating code smell.

Is there a library like https://github.com/thephpleague/fractal that allows me to transform my response into the types I need?

Upvotes: 2

Views: 637

Answers (1)

david
david

Reputation: 18288

In cases like this it's almost always better to fix the API to return data in a usable format rather than trying to post-process the result on the client.

In your case there are several routes you could take:

  1. Store the list as a JSON string directly in the database.

    This means you don't have to do any processing on the server and can just return it 'as is'. However you lose the ability to do queries on the data directly and need to resort to things like LIKE and string operations.

  2. Store the data relationally, and process it on the server to turn it into JSON

    Here you retain the ability to do queries on your data, but you may need to do several queries to get all the data you need and then connect it on the server. (eg. you would do one SELECT on the user table to get a user, and then you would need to do another SELECT on the friends table where the userid matches your first user. You would then need to merge these results to create your JSON.) This is usually the best way to do it.

  3. You can also turn the result into JSON directly inside the database engine using a user defined function. For example using https://github.com/mysqludf/lib_mysqludf_json#readme

    This is somewhat similar to 2, but it ties your stored procs to the JSON format.

Upvotes: 1

Related Questions