Hi im confused i got a select component on my app but i need to show options, values from my mysql table
[
{
“id”: 1,
“business_id”: 1,
“location_id”: “BL0001”,
“name”: “DBS Network”,
“landmark”: “0”,
“country”: “Panamá”,
“state”: “Los Santos”,
“city”: “Las Tablas”,
“zip_code”: “507”,
“invoice_scheme_id”: 1,
“invoice_layout_id”: 1,
“sale_invoice_layout_id”: 1,
“selling_price_group_id”: null,
“print_receipt_on_invoice”: 1,
“receipt_printer_type”: “browser”,
“printer_id”: null,
“mobile”: “6505339”,
“alternate_number”: null,
“email”: null,
“website”: “https://www.dbsnetwork.net”,
“featured_products”: null,
“is_active”: 1,
“default_payment_accounts”: “{"cash":{"is_enabled":"1"},"card":{"is_enabled":"1"},"cheque":{"is_enabled":"1"},"bank_transfer":{"is_enabled":"1"},"other":{"is_enabled":"1"},"custom_pay_1":{"is_enabled":"1"},"custom_pay_2":{"is_enabled":"1"},"custom_pay_3":{"is_enabled":"1"},"custom_pay_4":{"is_enabled":"1"},"custom_pay_5":{"is_enabled":"1"},"custom_pay_6":{"is_enabled":"1"},"custom_pay_7":{"is_enabled":"1"}}”,
“custom_field1”: null,
“custom_field2”: null,
“custom_field3”: null,
“custom_field4”: null,
“deleted_at”: null,
“created_at”: “2022-10-26T21:14:30Z”,
“updated_at”: “2022-10-26T21:30:27Z”
},
{
“id”: 2,
“business_id”: 1,
“location_id”: “BL0002”,
“name”: “Vehiculo 1”,
“landmark”: null,
“country”: “Panamá”,
“state”: “Los Santos”,
“city”: “Las Tablas”,
“zip_code”: “507”,
“invoice_scheme_id”: 1,
“invoice_layout_id”: 1,
“sale_invoice_layout_id”: 1,
“selling_price_group_id”: null,
“print_receipt_on_invoice”: 1,
“receipt_printer_type”: “browser”,
“printer_id”: null,
“mobile”: null,
“alternate_number”: null,
“email”: null,
“website”: null,
“featured_products”: null,
“is_active”: 1,
“default_payment_accounts”: “{"cash":{"is_enabled":"1"},"card":{"is_enabled":"1"},"cheque":{"is_enabled":"1"},"bank_transfer":{"is_enabled":"1"},"other":{"is_enabled":"1"},"custom_pay_1":{"is_enabled":"1"},"custom_pay_2":{"is_enabled":"1"},"custom_pay_3":{"is_enabled":"1"},"custom_pay_4":{"is_enabled":"1"},"custom_pay_5":{"is_enabled":"1"},"custom_pay_6":{"is_enabled":"1"},"custom_pay_7":{"is_enabled":"1"}}”,
“custom_field1”: null,
“custom_field2”: null,
“custom_field3”: null,
“custom_field4”: null,
“deleted_at”: null,
“created_at”: “2022-10-26T21:29:34Z”,
“updated_at”: “2022-10-26T21:30:17Z”
},
{
“id”: 3,
“business_id”: 1,
“location_id”: “BL0003”,
“name”: “Vehiculo 2”,
“landmark”: null,
“country”: “Panamá”,
“state”: “Los Santos”,
“city”: “Las Tablas”,
“zip_code”: “507”,
“invoice_scheme_id”: 1,
“invoice_layout_id”: 1,
“sale_invoice_layout_id”: 1,
“selling_price_group_id”: null,
“print_receipt_on_invoice”: 1,
“receipt_printer_type”: “browser”,
“printer_id”: null,
“mobile”: null,
“alternate_number”: null,
“email”: null,
“website”: null,
“featured_products”: null,
“is_active”: 0,
“default_payment_accounts”: “{"cash":{"is_enabled":"1"},"card":{"is_enabled":"1"},"cheque":{"is_enabled":"1"},"bank_transfer":{"is_enabled":"1"},"other":{"is_enabled":"1"},"custom_pay_1":{"is_enabled":"1"},"custom_pay_2":{"is_enabled":"1"},"custom_pay_3":{"is_enabled":"1"},"custom_pay_4":{"is_enabled":"1"},"custom_pay_5":{"is_enabled":"1"},"custom_pay_6":{"is_enabled":"1"},"custom_pay_7":{"is_enabled":"1"}}”,
“custom_field1”: null,
“custom_field2”: null,
“custom_field3”: null,
“custom_field4”: null,
“deleted_at”: null,
“created_at”: “2022-10-26T21:30:09Z”,
“updated_at”: “2022-10-26T21:30:09Z”
}
]
how i can parse that json result to get all my locations like when i do this select in mysql
so when i click select component just show locations Name column.
thank you