• State Not Answered
  • Replies 4 replies
  • Subscribers 10 subscribers
  • Views 80 views
  • Users 0 members are here
Related Discussions
Home » Discussions » General

How to store map data into database using record type

Ankush Sharma
Certified Senior Developer

I need to input data into the database utilizing the 'write to record data' service. I have mapped out the data and now require storage within the database.

I have converted all data to map now i want to store the same into the database

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Senior Developer
    Thank you, everyone! I've finally achieved what I set out to do. Your support means a lot to me. Thanks again!

    a!localVariables(
    local!sheetData: readExcelSheet(
    excelDocument: 192028,
    sheetNumber: 0,
    startRow: 2,
    numberOfColumns: 0
    ),
    local!mapData: cast(typeof(a!map()),local!sheetData),
    local!mapDataValues: cast(
    typeof({a!map()}),
    local!mapData.result
    ),
    a!forEach(
    items: local!mapDataValues,
    expression: 'recordType!{9c2d97ac-fe71-469b-ad46-b2b43d9e7376}TR Expense'(
    'recordType!{9c2d97ac-fe71-469b-ad46-b2b43d9e7376}TR Expense.fields.{21990edd-3e43-4c8e-a725-f51e22f6b9e9}expenseDetails': fv!item.values[1],
    'recordType!{9c2d97ac-fe71-469b-ad46-b2b43d9e7376}TR Expense.fields.{db6b765f-187d-43c7-88a7-deaf16361a63}expenseAmount': fv!item.values[2]
    )
    )
    )



Reply
  • 0
    Certified Senior Developer
    Thank you, everyone! I've finally achieved what I set out to do. Your support means a lot to me. Thanks again!

    a!localVariables(
    local!sheetData: readExcelSheet(
    excelDocument: 192028,
    sheetNumber: 0,
    startRow: 2,
    numberOfColumns: 0
    ),
    local!mapData: cast(typeof(a!map()),local!sheetData),
    local!mapDataValues: cast(
    typeof({a!map()}),
    local!mapData.result
    ),
    a!forEach(
    items: local!mapDataValues,
    expression: 'recordType!{9c2d97ac-fe71-469b-ad46-b2b43d9e7376}TR Expense'(
    'recordType!{9c2d97ac-fe71-469b-ad46-b2b43d9e7376}TR Expense.fields.{21990edd-3e43-4c8e-a725-f51e22f6b9e9}expenseDetails': fv!item.values[1],
    'recordType!{9c2d97ac-fe71-469b-ad46-b2b43d9e7376}TR Expense.fields.{db6b765f-187d-43c7-88a7-deaf16361a63}expenseAmount': fv!item.values[2]
    )
    )
    )



Children
No Data

© 2024 Appian. All rights reserved.