How to store map data into database using record type

Ankush Sharma

Certified Senior Developer

15 days ago

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

0 Abhishek Karumuru
Certified Senior Developer
15 days ago

hi Ankush Sharma Could you please share your code snippet please
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Ankush Sharma
Certified Senior Developer
15 days ago in reply to Abhishek Karumuru

Abhishek Karumuru

a!localVariables(
local!sheetData: readexcelsheetwithfilter(
excelDocument:192028,
sheetNumber:1,
startRow: 2,
endRow: null(),
startColumn:1,
endColumn: null()
).data,
local!values: a!forEach(
items: local!sheetData,
expression: fv!item
),
cast(
'type!Map?list',
local!values
)
)

Please check it out.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Venky Avuluri
Certified Senior Developer
15 days ago in reply to Ankush Sharma

Do you have respective recordtype?? If yes cast map to Record and use write records
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Ankush Sharma
Certified Senior Developer
15 days ago

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]
)
)
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel