Skip to content

Ask HN: Is there a visual data mapper for JSON transformation?

3 pointsCilvic4 comments
On HN

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?

Comments

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

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

Thanks, do you have a screenshot of the mapping / data transformations handy? I can only find this https://docs.n8n.io/data/data-mapping/data-mapping-ui/

AboutSource Built by g1lg1l

Hackerly is an independent reader for Hacker News, built on the public HN API. Not affiliated with Y Combinator.