API

Sales APIs

GET sales/recurring-invoice-plans/{recurringInvoicePlanId}/items/{itemId}

Get recurring invoice plan item

HTTP method GET
URI https://api.rambase.net/sales/recurring-invoice-plans/{recurringInvoicePlanId}/items/{itemId}
Supported formats Xml, Html, Json (ex. $format=json)
- URI parameter {recurringInvoicePlanId} Recurring invoice plan identifier
Integer, minimum 100000
- URI parameter {itemId} Recurring invoice plan item identifier
Integer, minimum 1
Custom fields Custom fields supported
Successful HTTP status code 200
API resource identifier 4395, version 42

The following body must be added to the request. Mouse over fieldnames for description and other useful information about the fields. Note that fields in bold are required/mandatory.

Format:
1
1

The query string is placed after the resource URL, seperated with a questionmark (?). The query string is composed of a series of query parameters with values. See the page about query parameters on how to use these parameters.

$showDomainDescriptions Boolean, optional Set to "true" to include domain descriptions for fields using domain values. See the Domain values page for more information. Default value is false.
$lang String, optional Specifies the language used in the response, following the 3-letter ISO-639-1 [lll]
$access_token String, optional After successful login you get an access token which needs to be provided in all API requests. Even though it is possible to pass this token as query parameter, we recommended passing it using the HTTP request header as described in Authorization. Note that all access tokens have an expiration time.
$db String, optional Set the database/company for the request
$format String, optional Set the format of the response to use for the request. Accepted values are "xml", "html", "jsonstream", "json"
$useMinimumVersion Integer, optional Used to run a new version of an API resource when your API client is running a deprecated API resource. See the Breaking changes page for more information.
$select String, optional Use to define the fields to return in the response. Accepts a comma-separated list of field names. See the Expand and select page for more information.
$showCustomFields Boolean, optional Set to "true" to include custom fields. Default value is false.

Read more about filters and sorting on how to use filter parameters and named filters.

Read more about filters and sorting on how to use sortable parameters

Requesting this resource will yield the following response. Mouse over fieldnames (or fieldgroups) for descriptions and other useful information about the fields. Fields colored in grey is expandable fields.

Please note that some fields may be removed from the response, based on user roles/duties/permissions.

Format:
1
<RecurringInvoicePlanItem>
2
     <RecurringInvoicePlanItemId
RecurringInvoicePlanItemId

Recurring invoice plan item identifier

>
{Integer}</RecurringInvoicePlanItemId>
3
     <CreatedAt
CreatedAt

Date of item creation

>
{Date}</CreatedAt>
4
     <Status
Status

Status of the item: 9 = Done, 4 = Active, 3 = Future

Possible domain values can be found here

>
{Integer}</Status>
5
     <Quantity
Quantity

Quantity of invoiced item

>
{Integer}</Quantity>
6
     <CustomersReferenceNumber
CustomersReferenceNumber

Customer item reference number. Comes originally from sales order item but updates independently.

>
{String}</CustomersReferenceNumber>
7
     <PriceChangeAgreement
PriceChangeAgreement

Type of recurring price (FIXED, MANUAL, AUTO). Defines if and how the recurring price can be updated.

Possible domain values can be found here

>
{Integer}</PriceChangeAgreement>
8
     <IsCalculating
IsCalculating

Boolean indicating if there is currently a batch running which processes this specific recurring invoice item

>
{Boolean}</IsCalculating>
9
     <Description
Description

Item description

>
{String}</Description>
10
     <CurrentPriceStep>
11
          <Price
Price

Value of a price step

>
{Decimal}</Price>
12
     </CurrentPriceStep>
13
     <Period>
14
          <StartAt
StartAt

Start date of the recurring invoice plan

>
{Datetime}</StartAt>
15
          <EndAt
EndAt

Actual end date and time of the recurring invoice plan

>
{Datetime}</EndAt>
16
          <ExpectedEndAt
ExpectedEndAt

Expected end date of the recurring invoice plan. Used for the prognosis.

>
{Datetime}</ExpectedEndAt>
17
     </Period>
18
     <Totals>
19
          <Currency
Currency

Three character code following the ISO 4217 standard

>
{String}</Currency>
20
          <EstimatedAmount
EstimatedAmount

Accumulated value of all amounts from recurring invoice periods

>
{Decimal}</EstimatedAmount>
21
          <AccruedAmount
AccruedAmount

Value of accrued amount from recurring invoice period

>
{Decimal}</AccruedAmount>
22
          <InvoicedAmount
InvoicedAmount

Accumulated value of invoiced amounts from recurring invoice periods

>
{Decimal}</InvoicedAmount>
23
          <ForecastAmount
ForecastAmount

Accumulated value of forecasted amounts

>
{Decimal}</ForecastAmount>
24
     </Totals>
25
     <RecurringPrice>
26
          <RecurringPriceId
RecurringPriceId

Recurring price indentifier

>
{Integer}</RecurringPriceId>
27
          <Currency
Currency

Three character code following the ISO 4217 standard

>
{String}</Currency>
28
          <PriceInterval
PriceInterval

Interval of recurring price

Possible domain values can be found here

>
{Integer}</PriceInterval>
29
          <HasOneTimeFee
HasOneTimeFee

Boolean indicating if the recurring price associated with the item has a one-time fee.

>
{Boolean}</HasOneTimeFee>
30
          <HasUsageStep
HasUsageStep

Boolean indicating if the recurring price associated with the item has any usage steps.

>
{Boolean}</HasUsageStep>
31
          <RecurringPriceLink
RecurringPriceLink

Recurring price indentifier

>
{String}</RecurringPriceLink>
32
     </RecurringPrice>
33
     <SalesOrderItem>
34
          <SalesOrderItemId
SalesOrderItemId

Sales order item identifier

>
{Integer}</SalesOrderItemId>
35
          <Product>
36
               <ProductId
ProductId

Product identifier

>
{Integer}</ProductId>
37
               <Name
Name

Name of the product

>
{String}</Name>
38
               <Description
Description

Description of the product

>
{String}</Description>
39
               <ProductLink
ProductLink

Product reference

>
{String}</ProductLink>
40
          </Product>
41
          <SalesOrder>
42
               <SalesOrderId
SalesOrderId

Sales order identifier

>
{Integer}</SalesOrderId>
43
               <SalesOrderLink
SalesOrderLink

Sales order reference

>
{String}</SalesOrderLink>
44
          </SalesOrder>
45
          <SalesOrderItemLink
SalesOrderItemLink

Reference to the sales order item.

>
{String}</SalesOrderItemLink>
46
     </SalesOrderItem>
47
     <Source>
48
          <RecurringInvoicePlanItemId
RecurringInvoicePlanItemId

Source item of recurring invoice plan. Used for tracking the source.

>
{Integer}</RecurringInvoicePlanItemId>
49
          <RecurringInvoicePlan>
50
               <RecurringInvoicePlanId
RecurringInvoicePlanId

Source identifier of recurring invoice plan. Used for tracking the source.

>
{Integer}</RecurringInvoicePlanId>
51
               <RecurringInvoicePlanLink
RecurringInvoicePlanLink

Recurring invoice plan reference

>
{String}</RecurringInvoicePlanLink>
52
          </RecurringInvoicePlan>
53
          <RecurringInvoicePlanItemLink
RecurringInvoicePlanItemLink

Reference to the recurring invoice plan item.

>
{String}</RecurringInvoicePlanItemLink>
54
     </Source>
55
     <Accounting
Accounting

Accounting details for the item, including fixed/system dimensions. For all dimensions, see seperate resource.

>
56
          <VATCodeDefinition>
57
               <VATCode
VATCode

Code that determines VAT rules used for VAT calculations.

>
{String}</VATCode>
58
               <VATPercent
VATPercent

Value added tax percent

>
{Decimal}</VATPercent>
59
          </VATCodeDefinition>
60
          <GeneralLedgerAccount>
61
               <GeneralLedgerAccountId
GeneralLedgerAccountId

General ledger account identifier

>
{Integer}</GeneralLedgerAccountId>
62
               <GeneralLedgerAccountLink
GeneralLedgerAccountLink

General ledger account reference

>
{String}</GeneralLedgerAccountLink>
63
          </GeneralLedgerAccount>
64
          <Department
Department

The department related to the item. One of the system/fixed account dimensions.

>
65
               <DepartmentId
DepartmentId

Department identifier

>
{Integer}</DepartmentId>
66
               <DepartmentLink
DepartmentLink

Finance department reference

>
{String}</DepartmentLink>
67
          </Department>
68
          <FinanceProject
FinanceProject

The finance project related to the item. One of the system/fixed account dimensions.

>
69
               <FinanceProjectId
FinanceProjectId

Finance project identifier

>
{Integer}</FinanceProjectId>
70
               <FinanceProjectLink
FinanceProjectLink

Finance project reference

>
{String}</FinanceProjectLink>
71
          </FinanceProject>
72
          <Asset
Asset

The asset related to the item. One of the system/fixed account dimensions.

>
73
               <AssetId
AssetId

Asset identifier

>
{Integer}</AssetId>
74
               <AssetLink
AssetLink

Asset reference

>
{String}</AssetLink>
75
          </Asset>
76
     </Accounting>
77
</RecurringInvoicePlanItem>
1
{
2
     "recurringInvoicePlanItem": {
3
          "recurringInvoicePlanItemId
RecurringInvoicePlanItemId

Recurring invoice plan item identifier

":
"{Integer}",
4
          "createdAt
CreatedAt

Date of item creation

":
"{Date}",
5
          "status
Status

Status of the item: 9 = Done, 4 = Active, 3 = Future

Possible domain values can be found here

":
"{Integer}",
6
          "quantity
Quantity

Quantity of invoiced item

":
"{Integer}",
7
          "customersReferenceNumber
CustomersReferenceNumber

Customer item reference number. Comes originally from sales order item but updates independently.

":
"{String}",
8
          "priceChangeAgreement
PriceChangeAgreement

Type of recurring price (FIXED, MANUAL, AUTO). Defines if and how the recurring price can be updated.

Possible domain values can be found here

":
"{Integer}",
9
          "isCalculating
IsCalculating

Boolean indicating if there is currently a batch running which processes this specific recurring invoice item

":
"{Boolean}",
10
          "description
Description

Item description

":
"{String}",
11
          "currentPriceStep": {
12
               "price
Price

Value of a price step

":
"{Decimal}"
13
          },
14
          "period": {
15
               "startAt
StartAt

Start date of the recurring invoice plan

":
"{Datetime}",
16
               "endAt
EndAt

Actual end date and time of the recurring invoice plan

":
"{Datetime}",
17
               "expectedEndAt
ExpectedEndAt

Expected end date of the recurring invoice plan. Used for the prognosis.

":
"{Datetime}"
18
          },
19
          "totals": {
20
               "currency
Currency

Three character code following the ISO 4217 standard

":
"{String}",
21
               "estimatedAmount
EstimatedAmount

Accumulated value of all amounts from recurring invoice periods

":
"{Decimal}",
22
               "accruedAmount
AccruedAmount

Value of accrued amount from recurring invoice period

":
"{Decimal}",
23
               "invoicedAmount
InvoicedAmount

Accumulated value of invoiced amounts from recurring invoice periods

":
"{Decimal}",
24
               "forecastAmount
ForecastAmount

Accumulated value of forecasted amounts

":
"{Decimal}"
25
          },
26
          "recurringPrice": {
27
               "recurringPriceId
RecurringPriceId

Recurring price indentifier

":
"{Integer}",
28
               "currency
Currency

Three character code following the ISO 4217 standard

":
"{String}",
29
               "priceInterval
PriceInterval

Interval of recurring price

Possible domain values can be found here

":
"{Integer}",
30
               "hasOneTimeFee
HasOneTimeFee

Boolean indicating if the recurring price associated with the item has a one-time fee.

":
"{Boolean}",
31
               "hasUsageStep
HasUsageStep

Boolean indicating if the recurring price associated with the item has any usage steps.

":
"{Boolean}",
32
               "recurringPriceLink
RecurringPriceLink

Recurring price indentifier

":
"{String}"
33
          },
34
          "salesOrderItem": {
35
               "salesOrderItemId
SalesOrderItemId

Sales order item identifier

":
"{Integer}",
36
               "product": {
37
                    "productId
ProductId

Product identifier

":
"{Integer}",
38
                    "name
Name

Name of the product

":
"{String}",
39
                    "description
Description

Description of the product

":
"{String}",
40
                    "productLink
ProductLink

Product reference

":
"{String}"
41
               },
42
               "salesOrder": {
43
                    "salesOrderId
SalesOrderId

Sales order identifier

":
"{Integer}",
44
                    "salesOrderLink
SalesOrderLink

Sales order reference

":
"{String}"
45
               },
46
               "salesOrderItemLink
SalesOrderItemLink

Reference to the sales order item.

":
"{String}"
47
          },
48
          "source": {
49
               "recurringInvoicePlanItemId
RecurringInvoicePlanItemId

Source item of recurring invoice plan. Used for tracking the source.

":
"{Integer}",
50
               "recurringInvoicePlan": {
51
                    "recurringInvoicePlanId
RecurringInvoicePlanId

Source identifier of recurring invoice plan. Used for tracking the source.

":
"{Integer}",
52
                    "recurringInvoicePlanLink
RecurringInvoicePlanLink

Recurring invoice plan reference

":
"{String}"
53
               },
54
               "recurringInvoicePlanItemLink
RecurringInvoicePlanItemLink

Reference to the recurring invoice plan item.

":
"{String}"
55
          },
56
          "accounting
Accounting

Accounting details for the item, including fixed/system dimensions. For all dimensions, see seperate resource.

":
{
57
               "vATCodeDefinition": {
58
                    "vATCode
VATCode

Code that determines VAT rules used for VAT calculations.

":
"{String}",
59
                    "vATPercent
VATPercent

Value added tax percent

":
"{Decimal}"
60
               },
61
               "generalLedgerAccount": {
62
                    "generalLedgerAccountId
GeneralLedgerAccountId

General ledger account identifier

":
"{Integer}",
63
                    "generalLedgerAccountLink
GeneralLedgerAccountLink

General ledger account reference

":
"{String}"
64
               },
65
               "department
Department

The department related to the item. One of the system/fixed account dimensions.

":
{
66
                    "departmentId
DepartmentId

Department identifier

":
"{Integer}",
67
                    "departmentLink
DepartmentLink

Finance department reference

":
"{String}"
68
               },
69
               "financeProject
FinanceProject

The finance project related to the item. One of the system/fixed account dimensions.

":
{
70
                    "financeProjectId
FinanceProjectId

Finance project identifier

":
"{Integer}",
71
                    "financeProjectLink
FinanceProjectLink

Finance project reference

":
"{String}"
72
               },
73
               "asset
Asset

The asset related to the item. One of the system/fixed account dimensions.

":
{
74
                    "assetId
AssetId

Asset identifier

":
"{Integer}",
75
                    "assetLink
AssetLink

Asset reference

":
"{String}"
76
               }
77
          }
78
     }
79
}

Possible error codes the response might return:

Error 102738 HTTP 404 Price list not found
Error 100055 HTTP 403 You have only admittance to your own objects
Error 105970 HTTP 400 End date is required