Skip to main content
V
vikashk7323
August 30, 2023
Question

How to write Data and related data in records in 23.3

  • August 30, 2023
  • 12 replies
  • 1 view

I have a table with 1:M relationship, as stated in 23.3 I can update with just one write records smart service, how to pass related data there

12 replies

V
vikashk7323Author
August 30, 2023

Got it the rule inputs should be modified to store related data

S
shivakanthreddyp0001
August 30, 2023

Hi Kumar,
you need a create record relationship first and and all the records must under same data source. you can build record data using record type or have variable of type that record.

you can refer for detailed info here
docs.appian.com/.../Write_Records_Smart_Service.html

stefanhelzle0001
stefanhelzle0001
Brainy
August 30, 2023

You will find the record relationships in the parent data structure just like a field name. Populate these fields and you are good to go.

L
laurag950
October 11, 2023

Hi Stefan, hope you can help me, I'm trying to create a record in a table and update a field in other, both are related with records. Is it correct the way am I populating the data?

the last line (second value of 7)  is the related value. 

It is giving me only de new record in the first table, but it doesn't update the value in the second one.

mathieud0001
mathieud0001
August 30, 2023

You can build your record in such a way and use in a Write Records node. It will populate the vehiculeId on the related record on its own.

L
laura.marin
August 30, 2023

Also here's an additional doc reference, recently updated to provide additional related record writes guidance - docs.appian.com/.../manage-record-data.html

niharranjanh0001
niharranjanh0001
September 25, 2023

I am trying the same but it is not working . I have a record type case and one more called tasks. but in a single writerecord it is failing saying the child record's foreign key firled value can not be null

stefanhelzle0001
stefanhelzle0001
Brainy
September 25, 2023

More details please. Code snippets, screenshots, error messages, record config, etc..

harshitb6843
harshitb6843
February 13, 2024

I explained this in my new blog post that talks about how you can effectively write related data along with main data - https://appianspace.com/2024/02/13/write-related-records/

[View:https://appianspace.com/2024/02/13/write-related-records/:320:50]

Terms & ConditionsAccessibility statement