Other: Retrieve connector schema endpoint should display parent-child tables relation in the response
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.
Please sign in to leave a comment.
Comments
0 comments