Is there a way to append a record value to Data Store's add_update_record without replacing the whole value?

Help
1

This topic was automatically generated from Slack. You can find the original thread here.

Does anyone know if there’s a way to the Data Store add_update_record to append a record value without replacing the whole value?

2

There isn’t a pre-built action that does this (we should add one), but I think you’d need to ensure the record you’re storing is an array, then you can push() the new value on, like so:

originalArray.push(newValueOrArrayToAppend)
3

Thanks! I was hoping to avoid using Node but that’s alright for now

4

There isn’t by chance a REST API for data stores, are there?

5

Right now, I created a webflow to get and return all the records, which works fine

6

There isn’t right now, no — can you tell me more about your use case for a REST API?

7

Well, I need to change a decent amount of records, so it would be nice to do that server-side and sync it back up

8

But it’s not a big deal

9

Btw I just created a ticket to track the new action to append a record Slack

10

I see that, thanks!

11

FYI Keith, we just published this action to our public registry: https://pipedream.com/apps/data-stores/actions/append-to-record

12

That’s amazing! Thank you so much! I’ve very impressed on how quickly you were able to make that change

13

Let me know if it works for you and if you have any feedback!