Simplified table with terms / planned turnover by date

Questions (nl)
,
1

I am missing a table in the Simplicate database that I did find through an earlier report I made via their own API.

The table I am missing is: …..simplicate.nl/api/v2/projects/service?.....

In that table, you can find the planned revenue by date. In other words, the instalments. After modifications and removed columns, I end up with a table like the example below.

For me, it is important to be able to report the expected revenue. Can Invantive add this table?

data.project_id data.status data.invoice_in_installments data.installments.name data.installments.percentage data.installments.price data.installments.order data.installments.expiration_date data.installments.status data.id
project:5cdded26301bd24cfeaad60b7a7437df open TRUE Instalment 1 10 € 1 1 29-06-2025 invoice service:d6b87eaa9a526a72b61e8ec4cf9407af
project:5cdded26301bd24cfeaad60b7a7437df open TRUE Instalment 3 20 € 2 3 30-11-2025 open service:d6b87eaa9a526a72b61e8ec4cf9407af
project:5cdded26301bd24cfeaad60b7a7437df open TRUE Instalment 2 30 € 3 2 30-09-2025 open service:d6b87eaa9a526a72b61e8ec4cf9407af
3

What was the previously used full URL from /projects/service to the end?

5

The complete URL used is:

...simplicate.nl/api/v2/projects/service?offset=0&limit=100&sort=-end_date
6

The SQL tables used by the Invantive UniversalSQL driver for this purpose can be found with the query:

select type
,      name
,      odata_service_url_for_select
,      odata_base_path
from   SystemTables@DataDictionary
where  odata_service_url_for_select like '/projects/service%'
order
by     type
,      name

resulting in the following tables and the source of the retrieved data:

TYPE NAME ODATA_SERVICE_URL_FOR_SELECT ODATA_BASE_PATH
table ProjectCostTypeServices /projects/service data[].cost_types[]
table ProjectHourTypeServices /projects/service data[].hour_types[]
table ProjectInstallmentServices /projects/service data[].installments[]
table ProjectServices /projects/service data[*]
tablefunction ProjectServiceById /projects/service/{id} data
tablefunction ProjectsService_DataCost_typesById /projects/service/{id} data.cost_types[*]
tablefunction ProjectsService_DataHour_typesById /projects/service/{id} data.hour_types[*]
tablefunction ProjectsService_DataInstallmentsById /projects/service/{id} data.installments[*]
tablefunction ServicePlanningBudgetById /projects/service/{id}/planningBudget data[*]

Is it possible to find the data through these tables, for example in ProjectInstallmentServices?