Extracting JSON values from API responses has always been a time-consuming task for me during workspace development. My previous workflow involved receiving an API response from HTTP Caller, pasting it into VS Code, saving it as JSON, opening a new FME Form Window, adding a JSON Reader, and then changing Schema Scan Mode to JSON Query before selecting a query.
To streamline this process, I created a transformer specifically for parsing JSON strings. This transformer dynamically sets feature attributes based on JSON paths and their corresponding values from a specified attribute of an incoming feature.
The transformer is particularly useful for handling deeply nested JSON structures, making data manipulation within FME workflows more effective and efficient.
Would you like to know more? Click here to find out more details!