Solved

Mapping Composite Key from API to Record type

Forum|Forum|2 years ago
January 26, 2024
7 replies
0 views

I'm working with data via API that uses composite keys and need to store the data in Record type. However, I understand that composite keys are not supported in record types. Could anyone suggest a way to handle this situation or provide any workarounds?

Best answer by stefanhelzle0001

I do not understand why you could not concatenate a date field ?!?

I was not talking about a custom record field, but about a normal text field in the database to hold that merged key. Then this can act as PK in the DB and in the record.

stefanhelzle0001

Brainy

Did you consider to just concatenate the key values into a single text field? Maybe in addition to the original fields which then will not be used as keys anymore.

B

blerinad9411Author

I could not concatenate the key values since one of them has date datatype, but I tried to create a random field to have it as ID and then to leave it as primary, but we are reading data from a web service therefore we couldn't sync a record type without having initially a unique primary key, so even if I create a custom field I could not mark it as primary

stefanhelzle0001Answer

Brainy

I do not understand why you could not concatenate a date field ?!?

I was not talking about a custom record field, but about a normal text field in the database to hold that merged key. Then this can act as PK in the DB and in the record.

mathieud0001

Brainy

Concatenated key is the only way to do it.

B

blerinad9411Author

thanks

Sign up

Login with SSO

Login to the community

Login with SSO