I have managed to get this to work, fetching an API response, and inserting data into my database primary and sub table, however, the only way I could make it work was to adjust my database column names to be identical to the “Key”: “Value” returned by the API.
Is there a way to get around this, where the database column name could be different.
Example:
API Response.
{
"name": "Paul",
"lastName": "Strydom",
"contacts": [
{
"phone": "1234567"
},
{
"phone": "9999999"
}
]
}
If my database table where the “phone” will be entered has a column named “phone” then this works.
If the column is named something like “user_phone_numbers” then it errors with a message
Unknown column 'phone' in 'field list'
If there was a way to map the API Keys in the sub arrays / objects to my database field names that would be ideal.
Or of course there is also always the distinct possibility I am just doing this wrong, if someone could please confirm.
Last updated: