Hi - I am trying to merge two sets of data sources that are returned as json objects. Both contain an id record that should identify key matches.
The first object is:
[{"_id":"620ed36d7a885056c92a6f82","id":"**DwWciGdRzawbBc5KGiYx**","dataType":"TEXT","fieldKey":"contact.practice_contact_email","name":"Practice Contact Email","picklistOptions":null,"placeholder":"","position":0},{"_id":"620edf8b1b78f6d90b8f5014","id":"**uUIcwivyUObR1miXlDAN**","dataType":"SINGLE_OPTIONS","fieldKey":"contact.salutation","name":"Salutation","picklistOptions":["Dr.","Mr.","Ms.","Mrs.","Mx."],"placeholder":"Dr., Mr., Mrs., etc.","position":1},{"_id":"620edf8e1b78f6d90b8f501d","id":"**jBcIpxGdYiVMedDKimBj**","dataType":"TEXT","fieldKey":"contact.role","name":"Role","picklistOptions":null,"placeholder":"e.g. owner...","position":2},{"_id":"620edf901b78f6d90b8f5027","id":"**hdLlw9iUlaeuAC6rDMm9**","dataType":"TEXT","fieldKey":"contact.vc_loom_video_link","name":"VC Loom Video Link","picklistOptions":null,"placeholder":"Your loom video share link","position":3},{"_id":"620edf931b78f6d90b8f5030","id":"**5SbHCOdqySzLsV6xvp9f**","dataType":"TEXT","fieldKey":"contact.video_evaluation_image","name":"VC GIF Image","picklistOptions":null,"placeholder":"<a href=\"https://www.loom.com/share/....","position":4},{"_id":"620edf951b78f6d90b8f503a","id":"**FKh6cafaVCtYQFqTCbp6**","dataType":"LARGE_TEXT","fieldKey":"contact.video_eval_suggestions","name":"Video Eval Suggestions","picklistOptions":null,"placeholder":"[FB Messenger Ads, SEO... etc.]","position":5}]
The second looks like this:
{"id":"**0Jmm5F9wa7RXTQhgyYkg**","value":"https://drive.google.com/drive/folders/1UnH9oMT9ccTVubUzOOfbdMDN5K2pPJWs?usp=sharing"},
{"id":"**7Y3DG4k3vw4TdUSMGjVz**","value":null},
{"id":"**8fykUzPjlTOU3BLT5mCz**","value":"LeadGen"}]
These are from two different sources, one is an API and the other is a MongoDB, so I cannot do a JOIN.
Thanks for your help.