Other: Retrieve connector schema endpoint should display parent-child tables relation in the response
Answered
The Retrieve connector schema endpoint does not display the parent-child table relation in the response received.
Update: After syncing only deal_company table via API, the table did not get loaded probably because it's a child table and requires its parent table deals to be enabled for sync.
The response from the retrieve connector schema endpoint does not contain any such attributes.
{
"data": {
"schema_change_handling": "ALLOW_COLUMNS",
"enable_new_by_default": false,
"schemas": {
"dh_hubspot": {
"name_in_destination": "dh_hubspot",
"tables": {
"deal_property_history": {
"name_in_destination": "deal_property_history",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"engagement": {
"name_in_destination": "engagement",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"geolocation_analytics_daily_report": {
"name_in_destination": "geolocation_analytics_daily_report",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"engagement_communication": {
"name_in_destination": "engagement_communication",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"engagement_company": {
"name_in_destination": "engagement_company",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"line_item": {
"name_in_destination": "line_item",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"quote": {
"name_in_destination": "quote",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"utm_analytics_daily_report": {
"name_in_destination": "utm_analytics_daily_report",
"enabled_patch_settings": {
"reason_code": "OTHER",
"reason": "Not available in your HubSpot subscription or re-authorization may be required",
"allowed": false
},
"enabled": false
},
"quote_line_item": {
"name_in_destination": "quote_line_item",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"contact": {
"name_in_destination": "contact",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"quote_company": {
"name_in_destination": "quote_company",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"property": {
"name_in_destination": "property",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"utm_analytics_weekly_report": {
"name_in_destination": "utm_analytics_weekly_report",
"enabled_patch_settings": {
"reason_code": "OTHER",
"reason": "Not available in your HubSpot subscription or re-authorization may be required",
"allowed": false
},
"enabled": false
},
"email_event_sent": {
"name_in_destination": "email_event_sent",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"sessions_analytics_weekly_report": {
"name_in_destination": "sessions_analytics_weekly_report",
"enabled_patch_settings": {
"reason_code": "OTHER",
"reason": "Not available in your HubSpot subscription or re-authorization may be required",
"allowed": false
},
"enabled": false
},
"marketing_email": {
"name_in_destination": "marketing_email",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"deal_stage": {
"name_in_destination": "deal_stage",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"deal_company": {
"name_in_destination": "deal_company",
"enabled_patch_settings": {
"allowed": true
},
"enabled": true
},
"email_campaign": {
"name_in_destination": "email_campaign",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"engagement_contact": {
"name_in_destination": "engagement_contact",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"email_event_dropped": {
"name_in_destination": "email_event_dropped",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"ticket_contact": {
"name_in_destination": "ticket_contact",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"product_property_history": {
"name_in_destination": "product_property_history",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"quote_deal": {
"name_in_destination": "quote_deal",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"ticket_property_history": {
"name_in_destination": "ticket_property_history",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"deal_pipeline_stage": {
"name_in_destination": "deal_pipeline_stage",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"engagement_task": {
"name_in_destination": "engagement_task",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"marketing_email_contact": {
"name_in_destination": "marketing_email_contact",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"geolocation_analytics_weekly_report": {
"name_in_destination": "geolocation_analytics_weekly_report",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"email_event_bounce": {
"name_in_destination": "email_event_bounce",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"sources_analytics_daily_report": {
"name_in_destination": "sources_analytics_daily_report",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"ticket_pipeline_stage": {
"name_in_destination": "ticket_pipeline_stage",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"users": {
"name_in_destination": "users",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"sessions_analytics_overall_report": {
"name_in_destination": "sessions_analytics_overall_report",
"enabled_patch_settings": {
"reason_code": "OTHER",
"reason": "Not available in your HubSpot subscription or re-authorization may be required",
"allowed": false
},
"enabled": false
},
"deal_pipeline": {
"name_in_destination": "deal_pipeline",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"email_event_print": {
"name_in_destination": "email_event_print",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"ticket_deal": {
"name_in_destination": "ticket_deal",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"contact_list_member": {
"name_in_destination": "contact_list_member",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"engagement_email": {
"name_in_destination": "engagement_email",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"email_event_deferred": {
"name_in_destination": "email_event_deferred",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"email_event_status_change": {
"name_in_destination": "email_event_status_change",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"geolocation_analytics_monthly_report": {
"name_in_destination": "geolocation_analytics_monthly_report",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"deal": {
"name_in_destination": "deal",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"role": {
"name_in_destination": "role",
"enabled_patch_settings": {
"reason_code": "OTHER",
"reason": "Not available in your HubSpot subscription",
"allowed": false
},
"enabled": false
},
"email_event_forward": {
"name_in_destination": "email_event_forward",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"quote_property_history": {
"name_in_destination": "quote_property_history",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"contact_company": {
"name_in_destination": "contact_company",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"engagement_deal": {
"name_in_destination": "engagement_deal",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"email_event_suppressed": {
"name_in_destination": "email_event_suppressed",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"engagement_meeting": {
"name_in_destination": "engagement_meeting",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"association_type": {
"name_in_destination": "association_type",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"email_event_spam_report": {
"name_in_destination": "email_event_spam_report",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"email_subscription": {
"name_in_destination": "email_subscription",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"totals_analytics_daily_report": {
"name_in_destination": "totals_analytics_daily_report",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"email_event_delivered": {
"name_in_destination": "email_event_delivered",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"sources_analytics_overall_report": {
"name_in_destination": "sources_analytics_overall_report",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"email_subscription_change": {
"name_in_destination": "email_subscription_change",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"merged_deal": {
"name_in_destination": "merged_deal",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"marketing_email_campaign": {
"name_in_destination": "marketing_email_campaign",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"totals_analytics_monthly_report": {
"name_in_destination": "totals_analytics_monthly_report",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"deal_contact": {
"name_in_destination": "deal_contact",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"email_event_click": {
"name_in_destination": "email_event_click",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"engagement_note": {
"name_in_destination": "engagement_note",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"sessions_analytics_monthly_report": {
"name_in_destination": "sessions_analytics_monthly_report",
"enabled_patch_settings": {
"reason_code": "OTHER",
"reason": "Not available in your HubSpot subscription or re-authorization may be required",
"allowed": false
},
"enabled": false
},
"company": {
"name_in_destination": "company",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"utm_analytics_overall_report": {
"name_in_destination": "utm_analytics_overall_report",
"enabled_patch_settings": {
"reason_code": "OTHER",
"reason": "Not available in your HubSpot subscription or re-authorization may be required",
"allowed": false
},
"enabled": false
},
"sources_analytics_weekly_report": {
"name_in_destination": "sources_analytics_weekly_report",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"owner_team": {
"name_in_destination": "owner_team",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"owner": {
"name_in_destination": "owner",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"quote_contact": {
"name_in_destination": "quote_contact",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"product": {
"name_in_destination": "product",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"utm_analytics_monthly_report": {
"name_in_destination": "utm_analytics_monthly_report",
"enabled_patch_settings": {
"reason_code": "OTHER",
"reason": "Not available in your HubSpot subscription or re-authorization may be required",
"allowed": false
},
"enabled": false
},
"ticket": {
"name_in_destination": "ticket",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"totals_analytics_weekly_report": {
"name_in_destination": "totals_analytics_weekly_report",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"engagement_property_history": {
"name_in_destination": "engagement_property_history",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"line_item_property_history": {
"name_in_destination": "line_item_property_history",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"geolocation_analytics_overall_report": {
"name_in_destination": "geolocation_analytics_overall_report",
"enabled_patch_settings": {
"allowed": true
},
"enabled": false
},
"team_user": {
"name_in_destination": "team_user",
"enabled_patch_settings": {
"allowed": true
Please add the feature of displaying the parent-child table relation attribute in the response.
Thank you.
-
Official comment
Hi Astuti,
If I'm understanding correctly, you want to understand what you need to sync from source in order to produce valid table output in the destination. Not just foreign-key relationships.
> After syncing only deal_company table via API, the table did not get loaded probably because it's a child table and requires its parent table deals to be enabled for sync.
It sounds like you just want to know what tables are required to be enabled, not necessarily to articulate parent child relationships. Let me know if that's accurate.
Jimmy
Please sign in to leave a comment.
Comments
1 comment