JSON_EXTRACT(api_response, '$.*.content') works fine and extracts all the required id from the payload