Title
#advice-data-transformation
Collin Rincon Scangarella

Collin Rincon Scangarella

06/15/2022, 5:41 PM
Hey all - I just set up a sync job on 0.39.18-alpha. My source is Facebook Marketing 0.2.51 and my destination is Postgresql 0.3.20. Unfortunately the connection errors out with the following issue:
function json_extract_array(jsonb, unknown) does not exist
Which makes sense, given that that function doesn't exist in postgresql (at least not on version 12, which is the database version). How can I get this working?
5:45 PM
Marcos Marx (Airbyte)

Marcos Marx (Airbyte)

06/15/2022, 5:52 PM
Status:  403
  Response:
    {
      "error": {
        "message": "(#200) Requires business_management permission to manage the object",
        "type": "OAuthException",
        "code": 200,
        "fbtrace_id": "ASgzo24jTvb53U2oKGxt20l"
      }
    }
5:53 PM
The normalization error is mislead, you had an error before getting the fb data
Collin Rincon Scangarella

Collin Rincon Scangarella

06/15/2022, 5:53 PM
Gotcha. Thank you Marcos