How to concatenate to an existing record in Data Store?

What are you trying to achieve?

I have a record with all previous dialogues with ChatGPT. I want to concatenate a newly created request and response to an existing record in order to keep context of the dialogue for further requests.

As I can see the module “Data Store => Update (which can concatenate) a record” needs a Key ID of the record (unique link to a record).

The question is: which method I should use to get this key from my record list ?

P.S. “Key” parameter in “Search records” returns sorting method and not the Key of the record

Steps taken so far

1 Like

Hi @Vitaly_Suturikhin

You should be able to map key from “search records”. There you can use filter also to retrieve the records and also can apply functions to update the record you want.

Regards,
Msquare Automation - Gold Partner of Make
@Msquare_Automation

Hi Msquare. Thank you for your answer.

I have already tried to do that. In the bottom right corner of my screenshot above there is a key field of Search records in Data Store.

However it returns the number of the element in the list when returning several records. Not the key (unique ID) or a link I’m searching to point the record out. It also can return fields of the record but not the pointer.

If you could share an example it would be very helpful and appreciated. Maybe I’m doing smthn wrong.

Any other ideas, fellows ? I’m struggling to move forward in creating an editable context for ChatGPT with native db without this.

1 Like

Hi @Vitaly_Suturikhin

Here’s an example.
I have the following records in my data store and I want the record where card name is “FIRST SWYP Credit Card”.

Now to get this record only, we can filter the results like below:

Regards,
Msquare Automation - Gold Partner of Make
@Msquare_Automation

Hi @Msquare_Automation !

Thank you for your sample. I see where I was wrong - my search returned empty result so I was missing “Key” as a value.

Much appreciated. YOu have helped me a lot

1 Like