Hey all - I just set up a sync job on 0.39.18-alph...
# advice-data-transformation
c
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?
m
Copy code
Status:  403
  Response:
    {
      "error": {
        "message": "(#200) Requires business_management permission to manage the object",
        "type": "OAuthException",
        "code": 200,
        "fbtrace_id": "ASgzo24jTvb53U2oKGxt20l"
      }
    }
The normalization error is mislead, you had an error before getting the fb data
c
Gotcha. Thank you Marcos