ContributionsMost RecentMost LikesSolutionsPipeline 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. Re: Live Chat with Others in The Qrew in Discord The Discord Channel link is invalid. Anyone have an updated link? Re: Time of Day field values are not in 24-hour format in Pipelines That worked. Thanks Doug! Re: Join multi-line text field to one line It could be any string that has multiple line breaks/spaces, and I need it to be converted into a single line without any line breaks. For example "blue green yellow" Convert to "blue green yellow" Time of Day field values are not in 24-hour format in Pipelines Hi all. I think I found a bug with Pipelines where using a Time of Day field isn't in 24-hour format even when you set the field settings to 24-hour. Can anyone think of a possible workaround? Most APIs use 24-hour format so having Pipelines only output in North American format makes it impossible to pass along the correct time format. Steps to reproduce: Create a Time of Day field. In field settings > Value display, enable 24-hour clock. Create a pipeline that sends a value in this field. Pipelines outputs the field in North American time format (for example, 5:00 PM), instead of 24-hour format (ex: 17:00). I tried using Jinja to reformat to 24-hour, but Pipelines doesn't support the jinja filters needed to re-format to 24-hour time. Here's the Jinja expression I tried: {{ time-field|replace(" AM", "").|replace(" PM", "")|stringptime("%I:%M")|strftime("%H:%M") }} SolvedRe: Join multi-line text field to one line Any ideas? Join multi-line text field to one line Hi all. I'm trying to find a way (either using a formula or in Pipelines) to join a multi-line text field to a single line. Use case: The multi-line text field will contain text that will go to the JSON request body of an API call in Pipelines, so the field needs to be converted to a single line. The field has to a multi-line text field, because values can contain several paragraphs and app users can easily customize it. Thanks! Re: Share your feedback on the new Qrew Discussions Any updates on the inability to paste in text when replying or creating a new post? This should be basic functionality that should work. Re: Share your feedback on the new Qrew Discussions File attachments working for me now, but still can't paste content into replies or new posts. Tried using shortcuts and right-click > Paste. Re: Share your feedback on the new Qrew Discussions I also noticed many issues with copying and pasting content into the new post editor. Also, issues with attaching files (clicking the attach icon doesn't do anything).