invantive documentation
Invantive Support ForumsLog In / Sign Up

SubscriptionGroupedLinesBySubscriptionId: Teamleader Focus Subscription Grouped Lines by Subscription ID

read only REST

  • Catalog: Teamleader
  • Schema: V2
  • Primary Keys: id
  • Label: Subscription Grouped Lines by Subscription ID

Can only retrieve data.

API Source

  • Endpoint: subscriptions.info

Performance Characteristics

Characteristic Value
Average access latency (ms) 39

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
id ``

Table Columns

The columns of the table SubscriptionGroupedLinesBySubscriptionId 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 and update.

Name Data Type Label Required Marks Documentation
section_title varchar2 Section Title filters on the platform, writable, section.title
subscription_billing_cycle_days_in_advance varchar2 Subscription Billing Cycle Days in Advance filters on the platform, writable, ::ancestor.billing_cycle.days_in_advance
subscription_billing_cycle_periodicity_period varchar2 Subscription Billing Cycle Periodicity Period filters on the platform, writable, ::ancestor.billing_cycle.periodicity.period
subscription_billing_cycle_periodicity_unit varchar2 Subscription Billing Cycle Periodicity Unit filters on the platform, writable, ::ancestor.billing_cycle.periodicity.unit
subscription_currency varchar2 Subscription Currency filters on the platform, writable, ::ancestor.currency
subscription_department_id varchar2 Subscription Department ID filters on the platform, writable, ::ancestor.department.id
subscription_ends_on datetime Subscription Ends on filters on the platform, writable, ::ancestor..ends_on
subscription_id varchar2 Subscription ID filters on the platform, writable, ::ancestor.id
subscription_invoicee_customer_id varchar2 Subscription Invoicee Customer ID filters on the platform, writable, ::ancestor.invoicee.customer.id
subscription_invoicee_customer_type varchar2 Subscription Invoicee Customer Type filters on the platform, writable, ::ancestor.invoicee.customer.type
subscription_invoicee_for_attention_of_contact_id varchar2 Subscription Invoicee for Attention of Contact ID filters on the platform, writable, ::ancestor.invoicee.for_attention_of.contact.id
subscription_invoicee_for_attention_of_contact_type varchar2 Subscription Invoicee for Attention of Contact Type filters on the platform, writable, ::ancestor.invoicee.for_attention_of.contact.type
subscription_invoicee_for_attention_of_name varchar2 Subscription Invoicee for Attention of Name filters on the platform, writable, ::ancestor.invoicee.for_attention_of.name
subscription_invoicee_name varchar2 Subscription Invoicee Name filters on the platform, writable, ::ancestor.invoicee.name
subscription_invoicee_vat_number varchar2 Subscription Invoicee VAT Number filters on the platform, writable, ::ancestor.invoicee.vat_number
subscription_next_renewal_date datetime Subscription Next Renewal Date filters on the platform, writable, ::ancestor.next_renewal_date
subscription_note varchar2 Subscription Note filters on the platform, writable, ::ancestor.note Uses Markdown formatting.
subscription_project_id varchar2 Subscription Project ID filters on the platform, writable, ::ancestor.project.id
subscription_starts_on datetime Subscription Starts on filters on the platform, writable, ::ancestor..starts_on
subscription_status varchar2 Subscription Status filters on the platform, writable, ::ancestor.status
subscription_title varchar2 Subscription Title filters on the platform, writable, ::ancestor.title
subscription_total_tax_exclusive_amount decimal Subscription Total Tax Exclusive Amount filters on the platform, writable, ::ancestor.total.tax_exclusive.amount
subscription_total_tax_exclusive_before_discount_amount decimal Subscription Total Tax Exclusive before Discount Amount filters on the platform, writable, ::ancestor.total.tax_exclusive_before_discount.amount
subscription_total_tax_exclusive_before_discount_currency varchar2 Subscription Total Tax Exclusive before Discount Currency filters on the platform, writable, ::ancestor.total.tax_exclusive_before_discount.currency
subscription_total_tax_exclusive_currency varchar2 Subscription Total Tax Exclusive Currency filters on the platform, writable, ::ancestor.total.tax_exclusive.currency
subscription_total_tax_inclusive_amount decimal Subscription Total Tax Inclusive Amount filters on the platform, writable, ::ancestor.total.tax_inclusive.amount
subscription_total_tax_inclusive_before_discount_amount decimal Subscription Total Tax Inclusive before Discount Amount filters on the platform, writable, ::ancestor.total.tax_inclusive_before_discount.amount
subscription_total_tax_inclusive_before_discount_currency varchar2 Subscription Total Tax Inclusive before Discount Currency filters on the platform, writable, ::ancestor.total.tax_inclusive_before_discount.currency
subscription_total_tax_inclusive_currency varchar2 Subscription Total Tax Inclusive Currency filters on the platform, writable, ::ancestor.total.tax_inclusive.currency
subscription_web_url varchar2 Subscription Web URL filters on the platform, writable, ::ancestor.web_url

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: