Stack Overflow
Stack Overflow

Questions tagged [nmbrs]

The Nmbrs API is a developer's interface to interact with the online Nmbrs payroll system.

This API is implemented as Soap XML Webservices and is available at [https://api.nmbrs.nl][1]. If you are a developer, you are encouraged to use the Nmbrs® Developer API and join a growing list of applications. Integration with Nmbrs® widens the scope of your application and provides an easy and effective way to reach new audiences.

7 questions
1
vote
1 answer

Retrieving inactive employees

I have the following query using the Invantive Query Tool connecting to NMBRS. select e.number , es.EmployeeId , e.displayname , es.ParttimePercentage , es.startdate from Nmbrs.Employees.EmployeeSchedules es left outer…
RS Finance
  • 224
  • 1
  • 9
1
vote
1 answer

How to get debtors from numbers for top 3 partitions

I want to get debtors from numbers from TOP 3 partitions. I am using this query to select partitions: use select top 1 code, data_container_alias from systempartitions@datadictionary where data_container_alias = 'nmbrs' And this query to get…
Andrius V.
  • 134
  • 1
  • 8
1
vote
0 answers

Get employee ID from NMBRS API

I have to query employee salaries information for statistical analysis. But using invantive-control and invantive query tool all EmployeeId fields are empty. And I need this field to add additional information. My question is how can I get…
Andrius V.
  • 134
  • 1
  • 8
1
vote
1 answer

Connect to SQL Server and Nmbrs in one session

I would like to insert data into SQL Server directly from NMBRS in a distributed transaction, like for instance: insert into table@sqlserver ( fields ) select fields from employees@nmbrs By default only the datadictionary, inmemorystorage, os and…
Andrius V.
  • 134
  • 1
  • 8
1
vote
1 answer

Restrict list of employees in NMBRS to just a few companies

I am creating a report on sick leave on nmbrs.nl using Invantive SQL. By default this query retrieves data across all companies: select * from employees emp join employeeabsence(emp.id) This takes an enormous amount of time since for each…
Andrius V.
  • 134
  • 1
  • 8
0
votes
1 answer

Invantive Query Tool error querying NMBRS.nl

I want to run a query in Nmbrs.nl getting the journal information of a run. So I selected a company by using: using 111111 Then the following query to get the run info: select * from CompanyRunsYear(2017) This gives me a list of the runs in…
RS Finance
  • 224
  • 1
  • 9
0
votes
1 answer

Integrate ADO.NET provider on On-premise Data Gateway with PowerApps

I am trying to integrate a large number of data sources available through a custom ADO.NET provider on a Windows server into PowerApps. To make the data available, I am using v14 of the On-premise Data Gateway (non-personal mode). The gateway…
Guido Leenders
  • 4,232
  • 1
  • 23
  • 43