HACKER Q&A
📣 Cilvic

Is there a visual data mapper for JSON transformation?


For building integrations between APIs I'm often faced with stichting those apis together and transforming the data.

Situation: I have some source json, from some APIs/webhooks and some target json how I need to send it out

Complication: I need to transform it and re-map the fields. Depending on the complexity of the objects that might require some fiddling

Solution: I'd love a visual data mapper that allows me to

1. see the source and target spec 2. example values maybe even API descriptions 3. create simple transformation with Type/Javascript, JQ, JMESpath or similar 4. connect the target and source values visually 5. documentation - the visual aspect is important to help readers, as this is easier to understand/digest the integration, not only "build" it. Also it serves as a kind of todo-list. It's easy to see if something isn't mapped yet.

Any recommendations?


  👤 Cilvic Accepted Answer ✓
Candidates:

- https://ballerina.io/learn/vs-code-extension/implement-the-c... Data Mapper is pretty spot on, but is ballerina, a language I'm not familiar with yet. Does this exist for Javascript?

- https://www.postman.com/product/flows/ - can this do object mapping or only "steps" of the flow?

- Another one I found just now, but it's not "visual" https://jolt-demo.appspot.com/#incept


👤 throwaway888abc
I believe you can achieve that with n8n. Used in past (and still running) for some data transformation and little more. Possibly similar case what are you describing.

https://n8n.io/ https://github.com/n8n-io/n8n