Skip to main content

Community

Connector Improvement: prevent updates for already-deleted records

Answered

Please sign in to leave a comment.

Comments

3 comments

  • Official comment

    Hi Bryan Estrada, Drew from the product team here!

    Thanks for this request. Could I ask you for a few more details?

    Is this related to the metadata schema or reports? Are "deleted" entities never useful to sync?

    Drew the facebook records that are deleted are part of the _metadata schema_, not reports. Here is an example object -- I presume Fivetran's connector invokes the marketing api to retrieve it:

    https://developers.facebook.com/docs/marketing-api/reference/ad-campaign-group/

    There is an `effective_status` attribute that can be `DELETED`. This object is useful to know that it exists the first time and indeed every time that `effective_status<>DELETED`, but as soon as `effective_status == DELETED` the object will never change.

    Because the object never changes, I do not expect Fivetran to import it every time basically telling me "your deleted object is still deleted". My data warehouse already knows that and the object is not going to change anymore. You cannot undelete an object like this in Facebook.

    Thank you for the confirmation. I'll work with engineering to evaluate how we can support.

Didn’t find what you need?

Contact support