IntegrationHTTP-methodResourceDTDExample
Import travel expensePOSTtripexpense.nvtripexpense.dtdDownload
Import working hoursPOSTworkday.nvworkday.dtdDownload
Get working hoursGETgetworkday.nv Download
Get working hours from time periodGETgetworkdays.nv
Download
Get record type listGETgetrecordtypelist.nv

Delete workdayhourGETdeleteworkdayhour.nv

Import travel expense

Resource: tripexpense.nv

Request:

LevelElement nameType and lengthOccursDescriptionExample
RootrootAggr.1  
1tripexpenseAggr1  
2headerString1Header of the invoiceTrip expense
2descriptionString0...1Free description for invoice 
2customlinesAggr.0...1  
3customlineAggr.1...n  
4employeeidentifierString1Identifier of the employee, either number, finnish personal identifier or netvisorkey140785-xxxx
Attr.typeString0...1Type of identifier number or finnishpersonalidentifierfinnishpersonalidentifier
4ratioString1Type of Expense
HTTP-header X-Netvisor-Interface-Language=FI
affects to the name of ratio
Majoituskulut
Attr.typeString1Type of identifier name name
4amountNumeric1Amount of expense1,00
4customlineunitpriceNumeric1Unit price of the expense 150,00
Attr.iso4217currencycodeString0...1Currency used EUR
Attr.currencyrateNumeric0...1Currency exchange rate 
4vatpercentageNumeric0...1VAT percentage 24
4linedescriptionString1Description of the line Hotel bill
4begindateDate1Begin date2018-10-05
4enddateDate1End date2018-10-05
4crmprocessidentifierString0...1Identifier of a related CRM process  
4customeridentifierString0...1Netvisor ID or customer codeNV#123456
Attr.typeString0...1Type of identifier, netvisor or customer customer
4expenseaccountnumberNumeric0...1Expense account number 1701
4linestatusString0...1Travel line status. Different statuses are open (unfinished), confirmed (acknowledged), contentsupervisiored (travel expense rows with factual verification performed), accepted (approved) and paid.Paid
4dimensionAggr.0...n  
5dimensionnameString1Dimension header. If the header can't be found in system, Netvisor will create itProject
5dimensionitemString1Dimension item. If the item can't be found in system, Netvisor will create it
Payroll
Attr.fatheridNumeric0...1  
4tripexpenseattachmentsAggr.0...1  
5tripexpenseattachmentAggr.1...n  
6mimetypeString1MIME-Type of the attachmentApplication/Pdf
6attachmentdescriptionString1DescriptionDescription
6filenameString1File name Description.pdf
6documentdataString1Attachment data as Base64 encoded stringBwgHBgoICAgLCgoLDhg...
2travellinesAggr.0...1  
3travellineAggr.1...n  
4employeeidentifierString1Identifier of the employee, either number or personal identification number 140785-xxyy
Attr.typeString0...1type of identifier used, number or finnishpersonalidentifierfinnishpersonalidentifier
4traveltypeString1Type of travel, allowed values:
car,
car_with_trailer,
car_with_caravan, car_with_heavy_cargo, car_with_big_machinery, car_with_dog, car_travel_in_rough_terrain, motorboat_max_50hp, motorboat_over_50hp, snowmobile,
atv,
motorbike,
moped,
other,
carbenefit
car
4passengeramountNumeric 1Amount of passenger 1
4kilometeramountNumeric1Kilometers travelled 252,00
4unitpriceNumeric0...1Price of a single unit, if not given will be retrieved from Netvisor based on mileage type5,50
4linedescriptionString1Description of the line  
4traveldateDate1Date of travel 2014-10-03
4routedescriptionString1Description of the route  
4crmprocessidentifierString0...1Identifier of related CRM process  
4customeridentifierString0...1Identifier of customer, either id or number  
Attr.typeString0...1Type of identifier, netvisor or customer  
4linestatusString0...1Travel line status. Different statuses are open (unfinished), confirmed (acknowledged), contentsupervisiored (travel expense rows with factual verification performed), accepted (approved) and paid.Paid
4dimensionAggr.0...n  
5dimensionnameString1Dimension header. If the header can't be found in system, Netvisor will create itProject
5dimensionitemString1Dimension item. If the item can't be found in system, Netvisor will create itPayroll
Attr.fatheridNumeric0...1  
4tripexpenseattachmentsAggr.0...1  
5tripexpenseattachmentAggr.1...n  
6mimetypeString1MIME type of the attachment Application/pdf
6attachmentdescriptionString1Description 
6filenameString1File name  
6documentdataString1Attachment as base64-encoded string 
2dailycompensationlinesAggr.0...1  
3dailycompensationlineAggr.1...n  
4employeeidentifierString1Identifier of the employee, either number or personal identifier 140785-xxxx
Attr.typeString0...1type of identifier, number tai finnishpersonalidentifierfinnishpersonalidentifier
4compensationtypeString1Type of compensation, DomesticFull, DomesticHalf tai Foreigndomesticfull
4amountNumeric 1Amount of compensation1
4unitpriceNumeric 0...1Price of compensation, if not given, will be retrieved from Netvisor based on compensations's type500,00
4linedescriptionString1 Day in Helsinki 
4timeofdepartureDate and time 1Date of departure, must include time2012-04-04 08:00:00.000
4returntimeDate and time 1Date of departure, must include time2012-04-04 16:00:00.000
4crmprocessidentifierString0...1 NV#123456 
4customeridentifierString0...1Identifier of customer, either id or number 
Attr.typeString0...1Type if identifeir used, either netvisor tai customernetvisor
4linestatusString0...1Travel line status. Different statuses are open (unfinished), confirmed (acknowledged), contentsupervisiored (travel expense rows with factual verification performed), accepted (approved) and paid.Paid
4dimensionAggr.0...n  
5dimensionnameString1Dimension header. If the header can't be found in system, Netvisor will create itProject
5dimensionitemString1Dimension item. If thitem can't be found in system, Netvisor will create itPayroll
Attr.fatheridNumeric0...1  
4tripexpenseattachmentsAggr.0...1  
5tripexpenseattachmentAggr.1...n  
6mimetypeString1MIME type of the attachment  
6attachmentdescriptionString1Description  
6filenameString1File name  
6documentdataString1Attachment as base64-encoded string

 

Import work time

Resource: workday.nv
Import work hours for day.

Request:

LevelElement nameType and lengthOccursDescriptionExample
RootrootAggr.1  
1workdayAggr.1  
2dateDate1Day which for work time entries are2013-10-30
Attr.formatString1Always ansiansi
Attr.methodString0...1replace or increment. Default is replace.replace
2employeeidentifierString1Data that is used to link entry to employee, social security number or employee number in Netvisor1407
Attr.typeString0...1Type of EmployeeIdentifier; personalidentificationnumber, number or netvisorkeynumber
Attr.defaultdimensionhandlingtypeString0...1none or usedefaultusedefault
2workdayhourAggr.0...n  
3hoursNumeric1Amount of hours *), Netvisor will round to two decimals7,5
3collectorratioString1Record type, must exist in Netvisor11
Attr.typeString0...1Linking type of record type, always numbernumber
3acceptancestatusString1Status of the work time entry, confirmed or acceptedaccepted
3descriptionString1Description of the work recordNormal work
3crmprocessidentifierString0...1CRM process' linking information 
Attr.billingtypeString1unbillable or billablebillable
3invoicingproductidentifierString0...1Invoicing product 
3customeridentifierString0...1Invoicing customerTest customer
Attr.typeString1netvisor or customernetvisor
3dimensionAggr.0...n  
4dimensionnameString1Title of the dimensionProject
4dimensionitemString1Name of the dimension. If dimension does not exists, Netvisor creates new onePayroll
Attr.fatheridNumeric0...1Id of the dimension's parent33
2workdaytimeAggr.0...n  
3starttimeofdayNumeric1Start time of working time recording8:00
3endtimeofdayNumeric1End time of working time recording16:00
3breaktimeNumeric1Break time in minutes30
Attr.typeString always minutesminute
3collectorratioString1Record type, must exist in Netvisor11 
Attr.typeString0...1Linking type of record type, always numbernumber 
3acceptancestatusString1Status of the work time entry, confirmed or acceptedaccepted
3descriptionString1Description of the work recordNormal work
3invoicingproductidentifierString0...1Invoicing product 
3dimensionAggr.0...n  
4dimensionnameString1Title of the dimensionproject
4dimensionitemString1Name of the dimension. If dimension does not exists, Netvisor creates new onePayroll

*) You can also import working time entries with record types that have days as units, such as annual leaves. In these cases you have to save the number of days for element "hours" (for example 1, when one day is saved as working time entry). To be able to use Netvisor's holiday calculation, annual leaves should always be imported with value 1.

Get working hours

Resource: getworkday.nv
Returns single employee's working hours for one day. 

ParameterOccursDescriptionExample
netvisorkey
Employee's netvisorkey
Note! Use either parameter netvisorkey or employeenumber, not both
123
employeenumber1Employee number in Netvisor
Note! Use either parameter netvisorkey or employeenumber, not both 
1407
workhourdate1Date2018-06-20

Response:

LevelElementType and lengthOccursDescriptionExample
rootRootAggr.1  
1WorkdayAggr.1  
2DateDate1Date2018-06-20
2WorkdayHourAggr.0...n  
3HoursDecimal1Number of working hours7,5
3CollectorRatioString1Record typeNormal working hours
Attr.NumberNumeric1Number of record type1
3AcceptanceStatusString1Status of the work time entry, confirmed or accepted accepted
3DescriptionString1DescriptionAccepted hours 
3CrmProcessNameString1CRM process' linking information 
3DimensionAggr.0...n  
4DimensionNameString1Title of dimensionProject
4DimensionitemString1Name of dimensionProject 1 

Get working hours from time period

Resource: getworkdays.nv

Returns single employee's working hours from selected time period. The maximum length of the time period is one calendar year.

ParameterOccursDescriptionExample
netvisorkey0...1Employee's netvisorkey
Note! Use either parameter netvisorkey or employeenumber, not both
1
employeenumber0...1Employee number in Netvisor
Note! Use either parameter netvisorkey or employeenumber, not both
1407
workhourstartdate1Start date of the time period2022-01-01
workhourenddate1End date of the time period2022-12-31

Response:

LevelElementType and lengthOccursDescriptionExample
rootRootAggr.1  
1WorkdaysAggr.1  
2WorkdayAggr.0...n  
3DateDate1Date2022-01-01
3WorkDayHourAggr.0...n

AttrNetvisorkeyString1Worktime recording's Netvisorkey
4HoursDecimal1Number of hours7,5
4CollectorRatioText1Record typeNormal working hours
Attr.NumberNumeric1Number of record type1
Attr.NetvisorkeyString1Record type netvisorkey
4AcceptanceStatusText1Status of the work time entry, confirmed or acceptedAccepted
4DescriptionText1Description 
4CrmProcessNameText1CRM process' linking information 
4DimensionAggr.0...n  
5DimensionNameText1Title of the dimensionProject
5DimensionItemText1Name of dimensionProject 1

 

Get record type list

Resource: getrecordtypelist.nv

Retrieves company's record type information

Response:

LevelElement nameType and lengthOccursDescriptionExample
RootrootAggr.1

1RecordTypesAggr.1

2RecordTypeAggr.0...n

3NamesAggr.1

4NameText3Name of the record type01. Normal working hours
Attr.ISO-319-1 CodeText
Record type's name's language: fi, se, enfi
3NetvisorkeyNumerical1Record Type's netvisorkey1
3RationumberNumerical1Record type's number, which is used in workday.nv to direct to record type's10
3CharactertypeNumerical1Record type's character1=working hours, 2=holiday, 5=other absence
3UnitTypeNumerical1Record Type's unit1=hour, 2=day

Delete workdayhour

Resource: deleteworkdayhour.nv

This resource allows to delete a working hour line, if it has not been paid or linked to a paycheck. Working hour line's netvisorkey can be retrieved with getworkdays.nv.

ParameterOccurs
Description
Example
netvisorkey1Working hours netvisorkey12

xml
(575 Bytes)
xml
xml
(1.38 KB)

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.