IntegrationHTTP-methodResourceDTDExample
Import travel expensePOSTtripexpense.nvtripexpense.dtdDownload
Import working hoursPOSTworkday.nvworkday.dtdDownload
Get working hoursGETgetworkday.nv Download

Import travel expense

Resource: tripexpense.nv

Request:

LevelElement nameType and lengthOccursDescriptionExample
RootrootAggr.1  
1tripexpenseAggr1  
2headerString1Header of the invoiceTrip expence
2descriptionString0...1Free description for invoice 
2customlinesAggr.0...1  
3customlineAggr.1...n  
4employeeidentifierString1Identifier of the employee, either number or finnish personal identifier 140785-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
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  
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
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

Recourse: 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 or numbernumber
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
 
3invoicingcustomeridentifierString0...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

Resurssi: getworkday.nv
Returns single employee'sworking hours for one day. 

ParameterOccursDescriptionExample
employeenumber1Emplyee number in Netvisor1407
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
3DescriptionString1Description
Accepted hours 
3CrmProcessNameString1CRM process' linking information 
3DimensionAggr.0...n  
4DimensionNameString1Title of dimensionProject
4DimensionitemString1Name of dimensionProject 1 

 

 


xml
(769 Bytes)
xml
xml
(575 Bytes)

Did you find it helpful? Yes No

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