• Top
  • New

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

by Cilvic on 4/30/2024, 6:51:05 PM with 4 comments
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?

  • by Cilvic on 4/30/2024, 6:52:08 PM

    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

  • by throwaway888abc on 4/30/2024, 6:55:43 PM

    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