Thanks @joseph.olstad. I think you might have missed the second image I attached where I show that I am using JSONPath. I also mentioned "Here's the mapping configs using JSONPath". You can see the syntax I'm using for attempting to map these properties. I also used an online JSONPath evaluator (https://jsonpath.com) to verify the mapping syntax.
For example, for mapping title I am using $.data[*].title which works on jsonpath.com
Please see image attached:
→
Thank you for the link @joseph.olstad. However this is not the solution for me since the object I am trying to map is wrapped in curley braces, not an array (as seen in my attached image).
Changed to use Database::getConnection()->condition() instead of new Condition('OR') as per
https://www.drupal.org/node/3159568 →
Patch for D9/10