I have an object like this and I want to get for exemple a simple list of all companies. After, what would be the code to filter the companies in a specific city or the companies starting with "N"?
[
{
"fieldData":
{
"City": "Nashville",
"Company": "Bohnen, Thomas P Esq",
"FirstName": "Cara",
"LastName": "Hingst",
"id": "B3840265-9363-4730-A6F4-D7F8DEACD5C3"
},
"modId": "5",
"portalData": {},
"recordId": "202"
},
{
"fieldData":
{
"City": "San Francisco",
"Company": "Monroeville Area Chmbr Commrce",
"FirstName": "Diane",
"LastName": "Ort",
"id": "DEB98ADD-1F65-473F-AC14-62D1FCBC0A47"
},
"modId": "2",
"portalData": {},
"recordId": "203"
},
{
"fieldData":
{
"City": "Charlottesville",
"Company": "Parks Arizona State",
"FirstName": "Zane",
"LastName": "Opunui",
"id": "74B41283-B468-49FC-9AC0-69A675E56821"
},
"modId": "2",
"portalData": {},
"recordId": "204"
},
{
"fieldData":
{
"City": "Las Vegas",
"Company": "Shick And Wesley",
"FirstName": "Lea",
"LastName": "Knighton",
"id": "4C37361D-D418-4973-9B2B-A6ACCF31F1C5"
},
"modId": "2",
"portalData": {},
"recordId": "205"
},
{
"fieldData":
{
"City": "Franklin",
"Company": "Micro Enterprises",
"FirstName": "Patsy",
"LastName": "Rezac",
"id": "7E50FD85-6EB5-4857-B671-E178C189052E"
},
"modId": "2",
"portalData": {},
"recordId": "206"
}
]