Quotes: HubSpot Quotes |
ListRead a page of quotes. Control what is returned via the `properties` query param.
Catalog: Quotes3
Schema: Basic
Label: Quotes
Retrieve: true
Insert: true
Update: false
Delete: false
Parameters of Table Function
The following parameters can be used to control the behaviour of the table function Quotes. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be evaluated using their default values.
Value specification by position is done by listing all values from the first to the last needed value. For example: a `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three.
Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third.
Name |
Data Type |
Required |
Default Value |
Documentation |
---|---|---|---|---|
after |
string |
☐ |
|
The paging cursor token of the last successfully read resource will be returned as the `paging.next.after` JSON property of a paged response containing more results. |
archived |
boolean |
☐ |
|
Whether to return only results that have been archived. |
Columns of Table Function
The columns of the table function Quotes are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
archived |
boolean |
Archived |
☐ |
|
archivedAt |
datetime |
Archived at |
☐ |
|
associations |
string |
Associations |
☐ |
|
createdAt |
datetime |
Created at |
☐ |
|
id |
string |
ID |
☐ |
|
prop_hs_all_accessible_team_ids |
string |
All Accessible Team IDs |
☐ |
|
prop_hs_all_assigned_business_unit_ids |
string |
All Assigned Business Unit IDs |
☐ |
|
prop_hs_all_owner_ids |
string |
All Owner IDs |
☐ |
|
prop_hs_all_team_ids |
string |
All Team IDs |
☐ |
|
prop_hs_allowed_payment_methods |
string |
Allowed Payment Methods |
☐ |
|
prop_hs_approver_id |
string |
Approver ID |
☐ |
|
prop_hs_archived |
boolean |
{res:itgen_hubspot_prop_hs_archived} |
☐ |
|
prop_hs_associated_deal_owner_id |
string |
{res:itgen_hubspot_prop_hs_associated_deal_owner_id} |
☐ |
|
prop_hs_collect_billing_address |
boolean |
Collect Billing Address |
☐ |
|
prop_hs_collect_shipping_address |
boolean |
Collect Shipping Address |
☐ |
|
prop_hs_comments |
string |
Comments |
☐ |
|
prop_hs_created_by_user_id |
decimal |
Created by User ID |
☐ |
|
prop_hs_createdate |
datetime |
Created at |
☐ |
|
prop_hs_currency |
string |
Currency |
☐ |
|
prop_hs_dealless_quote |
boolean |
{res:itgen_hubspot_prop_hs_dealless_quote} |
☐ |
|
prop_hs_display_tcv_on_quote |
boolean |
{res:itgen_hubspot_prop_hs_display_tcv_on_quote} |
☐ |
|
prop_hs_domain |
string |
{res:itgen_hubspot_prop_hs_domain} |
☐ |
|
prop_hs_esign_date |
datetime |
eSign Date |
☐ |
|
prop_hs_esign_enabled |
boolean |
eSign Enabled |
☐ |
|
prop_hs_esign_num_signers_completed |
decimal |
eSign Number of Signers Completed |
☐ |
|
prop_hs_esign_num_signers_required |
decimal |
eSign Number of Signers Required |
☐ |
|
prop_hs_expiration_date |
datetime |
Expiration Date |
☐ |
|
prop_hs_expiration_template_path |
string |
Expiration Template Path |
☐ |
|
prop_hs_feedback |
string |
Feedback |
☐ |
|
prop_hs_language |
string |
Language |
☐ |
|
prop_hs_lastmodifieddate |
datetime |
Last Modified Date |
☐ |
|
prop_hs_legacy_stripe_migrated |
boolean |
{res:itgen_hubspot_prop_hs_legacy_stripe_migrated} |
☐ |
|
prop_hs_line_item_global_term_hs_discount_percentage_enabled |
boolean |
Line Item Globel Term Discount Percentage Enabled |
☐ |
|
prop_hs_line_item_global_term_hs_discount_percentage |
string |
Line Item Globel Term Discount Percentage |
☐ |
|
prop_hs_line_item_global_term_hs_recurring_billing_period_enabled |
boolean |
Line Item Global Term Recurring Billing Period Enabled |
☐ |
|
prop_hs_line_item_global_term_hs_recurring_billing_period |
string |
Line Item Global Term Recurring Billing Period |
☐ |
|
prop_hs_line_item_global_term_hs_recurring_billing_start_date_enabled |
boolean |
Line Item Global Term Recurring Billing Start Date Enabled |
☐ |
|
prop_hs_line_item_global_term_hs_recurring_billing_start_date |
string |
Line Item Global Term Recurring Billing Start Date |
☐ |
|
prop_hs_line_item_global_term_recurringbillingfrequency_enabled |
boolean |
Line Item Global Term Billing Frequency Enabled |
☐ |
|
prop_hs_line_item_global_term_recurringbillingfrequency |
string |
Line Item Global Term Billing Frequency |
☐ |
|
prop_hs_locale |
string |
Locale |
☐ |
|
prop_hs_locked |
boolean |
Locked |
☐ |
|
prop_hs_logo_url |
string |
Logo (URL) |
☐ |
|
prop_hs_manually_signed |
boolean |
Manually Signed |
☐ |
|
prop_hs_merged_object_ids |
string |
Merged Object IDs |
☐ |
|
prop_hs_num_associated_deals |
decimal |
Number of Associated Deals |
☐ |
|
prop_hs_object_id |
decimal |
Object ID |
☐ |
|
prop_hs_object_source_detail_1 |
string |
{res:itgen_hubspot_prop_hs_object_source_detail_1} |
☐ |
|
prop_hs_object_source_detail_2 |
string |
{res:itgen_hubspot_prop_hs_object_source_detail_2} |
☐ |
|
prop_hs_object_source_detail_3 |
string |
{res:itgen_hubspot_prop_hs_object_source_detail_3} |
☐ |
|
prop_hs_object_source_id |
string |
{res:itgen_hubspot_prop_hs_object_source_id} |
☐ |
|
prop_hs_object_source_label |
string |
{res:itgen_hubspot_prop_hs_object_source_label} |
☐ |
|
prop_hs_object_source_user_id |
decimal |
{res:itgen_hubspot_prop_hs_object_source_user_id} |
☐ |
|
prop_hs_object_source |
string |
{res:itgen_hubspot_prop_hs_object_source} |
☐ |
|
prop_hs_payment_date |
datetime |
Payment Date |
☐ |
|
prop_hs_payment_enabled |
boolean |
Payment Enabled |
☐ |
|
prop_hs_payment_status |
string |
Payment Status |
☐ |
|
prop_hs_payment_type |
string |
Payment Type |
☐ |
|
prop_hs_pdf_download_link |
string |
PDF Download Link |
☐ |
|
prop_hs_pdf_generation_status |
string |
{res:itgen_hubspot_prop_hs_pdf_generation_status} |
☐ |
|
prop_hs_primary_color |
string |
Primary Color |
☐ |
|
prop_hs_public_url_key |
string |
Public URL Key |
☐ |
|
prop_hs_quote_amount |
decimal |
Quote Amount |
☐ |
|
prop_hs_quote_link |
string |
Quote Link |
☐ |
|
prop_hs_quote_number |
string |
Quote Number |
☐ |
|
prop_hs_quote_owner_id |
string |
{res:itgen_hubspot_prop_hs_quote_owner_id} |
☐ |
|
prop_hs_quote_total_preference |
string |
Quote Total Preference |
☐ |
|
prop_hs_read_only |
boolean |
Read-only |
☐ |
|
prop_hs_render_status |
string |
{res:itgen_hubspot_prop_hs_render_status} |
☐ |
|
prop_hs_sales_email_last_replied |
datetime |
Sales Email Last Replied |
☐ |
|
prop_hs_sender_company_address |
string |
Sender Company Address |
☐ |
|
prop_hs_sender_company_address2 |
string |
Sender Company Address 2 |
☐ |
|
prop_hs_sender_company_city |
string |
Sender Company City |
☐ |
|
prop_hs_sender_company_country |
string |
Sender Company Country |
☐ |
|
prop_hs_sender_company_domain |
string |
Sender Company Domain |
☐ |
|
prop_hs_sender_company_image_url |
string |
Sender Company Image (URL) |
☐ |
|
prop_hs_sender_company_name |
string |
Sender Company Name |
☐ |
|
prop_hs_sender_company_state |
string |
Sender Company State |
☐ |
|
prop_hs_sender_company_zip |
string |
Sender Company ZIP Code |
☐ |
|
prop_hs_sender_email |
string |
Sender Email |
☐ |
|
prop_hs_sender_firstname |
string |
Sender First Name |
☐ |
|
prop_hs_sender_image_url |
string |
Sender Image (URL) |
☐ |
|
prop_hs_sender_jobtitle |
string |
Sender Job Title |
☐ |
|
prop_hs_sender_lastname |
string |
Sender Last Name |
☐ |
|
prop_hs_sender_phone |
string |
Sender Phone |
☐ |
|
prop_hs_shared_team_ids |
string |
{res:itgen_hubspot_prop_hs_shared_team_ids} |
☐ |
|
prop_hs_shared_user_ids |
string |
{res:itgen_hubspot_prop_hs_shared_user_ids} |
☐ |
|
prop_hs_show_countersignature_box |
boolean |
Show Countersignature Box |
☐ |
|
prop_hs_show_signature_box |
boolean |
Show Signature Box |
☐ |
|
prop_hs_sign_status |
string |
{res:itgen_hubspot_prop_hs_sign_status} |
☐ |
|
prop_hs_slug |
string |
{res:itgen_hubspot_prop_hs_slug} |
☐ |
|
prop_hs_status |
string |
Status |
☐ |
|
prop_hs_store_payment_method_at_checkout |
boolean |
{res:itgen_hubspot_prop_hs_store_payment_method_at_checkout} |
☐ |
|
prop_hs_tcv |
decimal |
Total Contract Value |
☐ |
|
prop_hs_template_type |
string |
Template Type |
☐ |
|
prop_hs_template |
string |
Template |
☐ |
|
prop_hs_terms |
string |
Terms |
☐ |
|
prop_hs_test_mode |
boolean |
Test Mode |
☐ |
|
prop_hs_timezone |
string |
Timezone |
☐ |
|
prop_hs_title |
string |
Title |
☐ |
|
prop_hs_unique_creation_key |
string |
Unique Creation Key |
☐ |
|
prop_hs_updated_by_user_id |
decimal |
Updated by User ID |
☐ |
|
prop_hs_user_ids_of_all_notification_followers |
string |
User IDs of All Notification Followers |
☐ |
|
prop_hs_user_ids_of_all_notification_unfollowers |
string |
User IDs of All Notification Unfollowers |
☐ |
|
prop_hs_user_ids_of_all_owners |
string |
User IDs of All Owners |
☐ |
|
prop_hs_was_imported |
boolean |
Was Imported |
☐ |
|
prop_hubspot_owner_assigneddate |
datetime |
Owner Assigned Date |
☐ |
|
prop_hubspot_owner_id |
string |
Owner ID |
☐ |
|
prop_hubspot_team_id |
string |
Team ID |
☐ |
|
prop_notes_last_contacted |
datetime |
Notes Last Contacted |
☐ |
|
prop_notes_last_updated |
datetime |
Notes Last Updated |
☐ |
|
prop_notes_next_activity_date |
datetime |
Notes Next Activity Date |
☐ |
|
prop_num_contacted_notes |
decimal |
Number of Contacted Notes |
☐ |
|
prop_num_notes |
decimal |
Number of Notes |
☐ |
|
updatedAt |
datetime |
Updated at |
☐ |
|
18-12-2024 20:09 Version 24.1.33-BETA+5180