Skip to main content

Data mapping for Finnish population register

This mapping is used to fetch contact information from the Finnish population register via the Population register API.

Mapping

The mapping name is update.roaring.FinnishPopulationRegister.

Updated fields

  • Name

  • Address

Mapping table

Row

Source field

FA field

Script

1

JSONPath:$.person[0].personId.value

c.contactId

2

addressFi

output = ""

3

JSONPath:$.person[0].permanentDomesticAddress.addressFi

addressFi

4

addressSe

output = ""

5

JSONPath:$.person[0].permanentDomesticAddress.addressSe

addressSe

6

c.address1

output = ("[addressFi]" != "") ? "[addressFi]" : "[addressSe]"

7

JSONPath:$.person[0].permanentDomesticAddress.zipCode

c.zipCode

8

JSONPath:$.person[0].permanentDomesticAddress.postalDistrictFi

c.city

9

FIRSTNAME

output = ""

10

JSONPath:$.person[0].name.firstName

FIRSTNAME

11

SURNAME

output = ""

12

JSONPath:$.person[0].name.lastName

SURNAME

13

c.name

if("[FIRSTNAME]" != "" && "[SURNAME]" != "") {

   output = "[FIRSTNAME]" + " " + "[SURNAME]"

} else {

   output = ""

}

In this section: