Skip to main content
Question

Pipeline outputs unicode JSON instead of a standard JSON string

  • June 10, 2024
  • 0 replies
  • 125 views

Frontman
Forum|alt.badge.img+4

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.

This topic has been closed for replies.

QuickBaseJunkie
Forum|alt.badge.img+15

How are you passing the JSON from the run report step to the make request step?

Have you tried something like {{a.json|tojson}} ?

-Sharon
QuickBaseJunkie.com