# Saving object array directly to Tulip Tables

**URL:** <https://community.tulip.co/t/saving-object-array-directly-to-tulip-tables/14726>\
**Category:** Support, Troubleshooting, & Help\
**Tags:** connectors, tables\
**Created:** [May 14, 2025, 11:44pm UTC](https://community.tulip.co/t/saving-object-array-directly-to-tulip-tables/14726 "2025-05-14T23:44:33Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![lrising](https://avatars.discourse-cdn.com/v4/letter/l/da6949/32.png) [@lrising](https://community.tulip.co/u/lrising)\
**Post date:** [May 14, 2025, 11:44pm UTC](https://community.tulip.co/t/saving-object-array-directly-to-tulip-tables/14726/1 "2025-05-14T23:44:33Z")

</div>

I’m looking for an efficient way to save an object array queried from a sql database directly into Tulip tables as a series of new records.  
There must be a way to do this directly without deconstructing the object array into multiple child arrays and then looping through the multiple child arrays to create a series new table records, but I am having difficulty finding any documentation on this use case. Where can I find it? Thanks!

---

<div class="post-metadata">

**Author:** ![danielpomeranz](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/danielpomeranz/32/9379_2.png) [@danielpomeranz](https://community.tulip.co/u/danielpomeranz)\
**Post date:** [May 16, 2025, 2:53pm UTC](https://community.tulip.co/t/saving-object-array-directly-to-tulip-tables/14726/2 "2025-05-16T14:53:30Z")

</div>

Tulip currently does not natively support object storage and interaction in Tables.

At this moment the only solution is to use an expression and wrap the object with a TOTEXT() function to write a JSON of the object. This can be stored in a text column.

You will then need to use custom widgets or an intense combination of formulas to parse and unpack the string.

---

<div class="post-metadata">

**Author:** ![danielpomeranz](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/danielpomeranz/32/9379_2.png) [@danielpomeranz](https://community.tulip.co/u/danielpomeranz)\
**Post date:** [May 16, 2025, 3:02pm UTC](https://community.tulip.co/t/saving-object-array-directly-to-tulip-tables/14726/3 "2025-05-16T15:02:46Z")

</div>

It would be really cool if Tulip connectors could do this parsing for us. Preventing the need for custom widgets.

@Pete_Hartnett is there any way to parse a JSON string like so? This would allow you to write objects to a text column and then build a connector to extract them later.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/2/24a8dd7d2d6f961bfd286d609a00bee83b377d4e.png)

---

<div class="post-metadata">

**Author:** ![lrising](https://avatars.discourse-cdn.com/v4/letter/l/da6949/32.png) [@lrising](https://community.tulip.co/u/lrising)\
**Post date:** [May 19, 2025, 2:06pm UTC](https://community.tulip.co/t/saving-object-array-directly-to-tulip-tables/14726/4 "2025-05-19T14:06:07Z")

</div>

This would be a very useful functionality. My initial aim was even lower, though. If I have a Tulip table with, let’s say, three columns: [orderID (string), datetimeCreated (date time), isCompleted (boolean)] and I want to pull new orders over from a SQL db via a SQL connector, my SQL connector will output an object array with types string, bool, datetime. I want to save that object array into my Tulip table with the compatible columns and data types. Can Tulip support this?

---

<div class="post-metadata">

**Author:** ![danielpomeranz](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/danielpomeranz/32/9379_2.png) [@danielpomeranz](https://community.tulip.co/u/danielpomeranz)\
**Post date:** [May 19, 2025, 3:34pm UTC](https://community.tulip.co/t/saving-object-array-directly-to-tulip-tables/14726/5 "2025-05-19T15:34:38Z")

</div>

No, Tulip can only write records one at a time so all of the solutions here will require iterating.