Currently I’m working on an integration and migration product known as OpsHub Integration Manager. Where I’m syncing the HubSpot’s Ticket entity type to the another instance of HubSpot to corresponding Contact entity type.
Here I recently encountered with an unsusual condition. Where when I make the below mentioned search API call
1. Method Type : POST
2. Request URL: https://api.hubapi.com/crm/v3/objects/tickets/search
3. Request Body:
{“filterGroups”:[{“filters”:[{“propertyName”:“hs_lastmodifieddate”,“operator”:“GTE”,“value”:“1763599368155”,“values”:null}]}],“sorts”:[{“propertyName”:“hs_lastmodifieddate”,“direction”:“DESCENDING”}],“limit”:1,“after”:“0”,“properties”:[“closed_date”,“content”,“create_by”,“created_by”,“createdate”,“first_agent_reply_date”,“hs_added_to_waitlist_at”,“hs_all_accessible_team_ids”,“hs_all_associated_contact_companies”,“hs_all_associated_contact_emails”,“hs_all_associated_contact_firstnames”,“hs_all_associated_contact_lastnames”,“hs_all_associated_contact_mobilephones”,“hs_all_associated_contact_phones”,“hs_all_conversation_mentions”,“hs_all_owner_ids”,“hs_all_team_ids”,“hs_applied_sla_rule_config_at”,“hs_applied_sla_rule_config_id”,“hs_applied_sla_schedule_at”,“hs_applied_sla_schedule_id”,“hs_assigned_team_ids”,“hs_assignment_method”,“hs_auto_generated_from_thread_id”,“hs_conversations_originating_message_id”,“hs_conversations_originating_thread_id”,“hs_copied_at”,“hs_copied_by_user”,“hs_copied_from_ticket”,“hs_copied_ticket_source”,“hs_created_by_user_id”,“hs_createdate”,“hs_custom_inbox”,“hs_customer_agent_escalated_time”,“hs_customer_agent_ticket_status”,“hs_date_entered_1”,“hs_date_entered_2”,“hs_date_entered_3”,“hs_date_entered_4”,“hs_date_exited_1”,“hs_date_exited_2”,“hs_date_exited_3”,“hs_date_exited_4”,“hs_draft_user_ids”,“hs_email_subject”,“hs_external_object_ids”,“hs_feedback_last_ces_follow_up”,“hs_feedback_last_ces_rating”,“hs_feedback_last_survey_date”,“hs_file_upload”,“hs_first_agent_message_sent_at”,“hs_first_agent_message_sent_by”,“hs_first_assignee_type”,“hs_first_visitor_message_sentiment”,“hs_first_visitor_message_sentiment_score”,“hs_form_id”,“hs_form_submission_conversion_id”,“hs_help_desk_onboarding_ticket”,“hs_helpdesk_sort_timestamp”,“hs_in_helpdesk”,“hs_in_waitlist”,“hs_inbox_id”,“hs_is_closed”,“hs_is_closed_in_time_to_close_sla_count”,“hs_is_closed_in_time_to_first_response_sla_count”,“hs_is_latest_message_failed”,“hs_is_latest_message_hidden_from_all”,“hs_is_one_touch_ticket”,“hs_is_visible_in_help_desk”,“hs_last_closed_date”,“hs_last_email_activity”,“hs_last_email_date”,“hs_last_email_details”,“hs_last_email_type”,“hs_last_message_from_visitor”,“hs_last_message_received_at”,“hs_last_message_sent_at”,“hs_last_visitor_message_sentiment”,“hs_last_visitor_message_sentiment_score”,“hs_lastactivitydate”,“hs_lastcontacted”,“hs_lastmodifieddate”,“hs_latest_message_attachment_types”,“hs_latest_message_is_forwarded_email”,“hs_latest_message_is_thread_comment”,“hs_latest_message_seen_by_agent_ids”,“hs_latest_message_visible_to_visitor”,“hs_latest_message_visible_to_visitor_sent_at”,“hs_mentioned_note_user_ids”,“hs_mentions_user_ids”,“hs_merged_object_ids”,“hs_most_relevant_sla_status”,“hs_most_relevant_sla_type”,“hs_msteams_message_id”,“hs_nextactivitydate”,“hs_notes_last_activity”,“hs_notes_next_activity”,“hs_notes_next_activity_type”,“hs_num_associated_companies”,“hs_num_associated_conversations”,“hs_num_times_contacted”,“hs_number_of_touches”,“hs_object_id”,“hs_object_source”,“hs_object_source_detail_1”,“hs_object_source_detail_2”,“hs_object_source_detail_3”,“hs_object_source_id”,“hs_object_source_label”,“hs_object_source_user_id”,“hs_originating_channel_instance_id”,“hs_originating_email_engagement_id”,“hs_originating_generic_channel_id”,“hs_outbound_ticket”,“hs_overall_visitor_messages_sentiment”,“hs_overall_visitor_messages_sentiment_score”,“hs_owning_teams”,“hs_pinned_engagement_id”,“hs_pipeline”,“hs_pipeline_stage”,“hs_primary_company”,“hs_primary_company_id”,“hs_primary_company_name”,“hs_read_only”,“hs_resolution”,“hs_retroactive_sla_update_at”,“hs_sales_email_last_replied”,“hs_seen_by_agent_ids”,“hs_shared_team_ids”,“hs_shared_user_ids”,“hs_sla_operating_hours”,“hs_sla_pause_status”,“hs_snoozed_by_user_ids”,“hs_source_object_id”,“hs_source_url”,“hs_tag_ids”,“hs_thread_ids_to_restore”,“hs_ticket_category”,“hs_ticket_id”,“hs_ticket_language_ai_tag”,“hs_ticket_priority”,“hs_ticket_reopened_at”,“hs_time_in_1”,“hs_time_in_2”,“hs_time_in_3”,“hs_time_in_4”,“hs_time_to_close_in_operating_hours”,“hs_time_to_close_sla_at”,“hs_time_to_close_sla_status”,“hs_time_to_first_assign”,“hs_time_to_first_rep_assignment”,“hs_time_to_first_response_in_operating_hours”,“hs_time_to_first_response_sla_at”,“hs_time_to_first_response_sla_status”,“hs_time_to_next_response_sla_at”,“hs_time_to_next_response_sla_status”,“hs_unique_creation_key”,“hs_updated_by_user_id”,“hs_user_ids_of_all_notification_followers”,“hs_user_ids_of_all_notification_unfollowers”,“hs_v2_cumulative_time_in_1”,“hs_v2_cumulative_time_in_2”,“hs_v2_cumulative_time_in_3”,“hs_v2_cumulative_time_in_4”,“hs_v2_date_entered_1”,“hs_v2_date_entered_2”,“hs_v2_date_entered_3”,“hs_v2_date_entered_4”,“hs_v2_date_exited_1”,“hs_v2_date_exited_2”,“hs_v2_date_exited_3”,“hs_v2_date_exited_4”,“hs_v2_latest_time_in_1”,“hs_v2_latest_time_in_2”,“hs_v2_latest_time_in_3”,“hs_v2_latest_time_in_4”,“hs_waitlist_routing_targets”,“hs_waitlist_sort_value”,“hs_was_imported”,“hubspot_owner_assigneddate”,“hubspot_owner_id”,“hubspot_team_id”,“last_engagement_date”,“last_reply_date”,“notes_last_contacted”,“notes_last_updated”,“notes_next_activity_date”,“nps_follow_up_answer”,“nps_follow_up_question_version”,“nps_score”,“num_contacted_notes”,“num_notes”,“oh_created_by”,“oh_last_update”,“oh_updated_by”,“remote_id”,“remote_link”,“source_ref”,“source_thread_id”,“source_type”,“subject”,“tags”,“time_to_close”,“time_to_first_agent_reply”,“update_by”]}
The response I received was:
{“status”:“error”,“message”:“Invalid JSON input: a request body was expected, but none found”,“correlationId”:“e2767f73-af7a-4509-987d-951b16a39a12”,“category”:“VALIDATION_ERROR”}
I have validated this from my logs that while making this API call I have sent the above mentioned request body, but then as well, it returned the 400 status code with the validation error.
So anyone knows why this issue is occuring.
