Forum Discussion

Frontman's avatar
Qrew Trainee
2 months ago

Pipeline outputs unicode JSON instead of a standard JSON string

Hello all,

Use case: I'm building an integration with AI models where I send JSON-formatted data for analysis. The JSON-formatting data comes from the Quickbase run report API which outputs table data in standard JSON. So essentially, I'm sending JSON from Quickbase inside a JSON value to an AI model.

Issue: While passing the raw JSON to my AI model, Pipeline automatically converts the JSON to Unicode JSON with "u" characters. Example of how it looks in the Pipelines activity log:

Is there any way to use Jinja2 or some other method to make sure the JSON is a standard JSON? This will help the AI model better understand the data.