Get list of Junctions Connections

17 Jan 2024
13 Minutes to read
Contributors

Print
Dark
Light
PDF

Get list of Junctions Connections

Updated on 17 Jan 2024
13 Minutes to read
Contributors

Print
Dark
Light
PDF

Article summary

Did you find this summary helpful?

Thank you for your feedback

Get

/junction-connections/

Operation is used to get a list of Junctions Connections.

Junctions Connections data can be filtered by giving filtering parameters at HTTP querystring (see parameters).

Security

API Key

Header parameter nameAuthorization

Token issued for API consumer.

Query parameters

offset

integer

Offset to start returning results.

Minimum0

limit

integer

Limit number of results returned.

Minimum1

__any of the object fields__

string

Filters list by selected object field value. Supports structured queries via +__+ delimiter. Supports ending keywords via +__+ delimiter:

For string fields: istartswith, startswith, iendswith, endswith, contains, icontains, isnull
For numerics: gt, lt, gte, lte, isnull
For spatial fields: contains, isnull, within, intersects, disjoint, touches, overlaps, covers, coveredby Examples: +++usage_state__txt__istartswith=in+++ , +++plan__state__txt__startswith=In+++ , +++creation_date__gte=2019-01-02T15:32:01+++, +++location__within=POLYGON ((641503.89 6944059.81, 641406.52 6943933.87, 641369.48 6943772.48, 641474.25 6943704.74, 641873.78 6943735.96, 641848.38 6943975.15, 641607.08 6944167.76, 641653.11 6944102.15, 641503.89 6944059.81))+++

orderby

string

Selects the object field to order the returned objects by. Can be used to sort in reverse order with '-' prefix. Can have several ordering rules separated by comma. Can be used only for object own fields and does not supports structured queries. Example: orderby=creator,-creation_date

Responses

200

A result response object

Expand All

object

string (url)

Url to next page of the list if applicable. (Null if none)

string (url)

Url to previous page of the list if applicable. (Null if none)

Results

Array of object (JunctionConnection)

List of fetched Junctions Connections

object

Consumerpoint

object (ConsumerPoint)

Consumer point object

Address

object (Address)

buildingId

string

Building id

city

string

Building city name

cityAlt

string

Building city name in alternative language

country

string

Building country

createdBy

string

creator

createdTs

string (date-time)

Creation date and time

district

string

Building district

integer

Primary key

location

string (ewkt)

Geographical location

municipality

string

Building municipality

propertyId

string

Property number

province

string

Building province

streetname

string

Building street name

streetnameAlt

string

Building street name in alternative language

streetno

string

Building number

subdivision

string

Building municipality subdivision

updatedBy

string

Last updater

updatedTs

string (date-time)

Last update date time

usagePurpose

object (BuildingUsage)

Building usage purpose

groupname

Group name of constant

Valid values[ "BUILDING_USAGE" ]

integer

Unique id of constant

list_url

string (url)

Url to fetch all contants from this group

logical_txt

string

Logical textual value

txt

string

Human readable textual representation

usagePurposeAlt

object (AddressSecondaryUsage)

Address usage purpose

groupname

Group name of constant

Valid values[ "KN_ADDR_SPEC" ]

integer

Unique id of constant

list_url

string (url)

Url to fetch all contants from this group

logical_txt

string

Logical textual value

txt

string

Human readable textual representation

zipcode

string

Building zipcode

Addresses

object (Apartment)

address

object (Address)

buildingId

string

Building id

city

string

Building city name

cityAlt

string

Building city name in alternative language

country

string

Building country

createdBy

string

creator

createdTs

string (date-time)

Creation date and time

district

string

Building district

integer

Primary key

location

string (ewkt)

Geographical location

municipality

string

Building municipality

propertyId

string

Property number

province

string

Building province

streetname

string

Building street name

streetnameAlt

string

Building street name in alternative language

streetno

string

Building number

subdivision

string

Building municipality subdivision

updatedBy

string

Last updater

updatedTs

string (date-time)

Last update date time

usagePurpose

object (BuildingUsage)

Building usage purpose

groupname

Group name of constant

Valid values[ "BUILDING_USAGE" ]

integer

Unique id of constant

list_url

string (url)

Url to fetch all contants from this group

logical_txt

string

Logical textual value

txt

string

Human readable textual representation

usagePurposeAlt

object (AddressSecondaryUsage)

Address usage purpose

groupname

Group name of constant

Valid values[ "KN_ADDR_SPEC" ]

integer

Unique id of constant

list_url

string (url)

Url to fetch all contants from this group

logical_txt

string

Logical textual value

txt

string

Human readable textual representation

zipcode

string

Building zipcode

apartmentDivision

string

apartment division

apartmentLetter

string

apartment letter

apartmentNumber

string

apartment number

integer

Primary key

originProperty

string

apartment original property id

originalStreetno

string

apartment original streen number

usagePurpose

object (ApartmentUsage)

Apartment Usage purpose

groupname

Group name of constant

Valid values[ "APARTMENT_USAGE" ]

integer

Unique id of constant

list_url

string (url)

Url to fetch all contants from this group

logical_txt

string

Logical textual value

txt

string

Human readable textual representation

usagePurposeAlt

object (AddressSecondaryUsage)

Address usage purpose

groupname

Group name of constant

Valid values[ "KN_ADDR_SPEC" ]

integer

Unique id of constant

list_url

string (url)

Url to fetch all contants from this group

logical_txt

string

Logical textual value

txt

string

Human readable textual representation

usageState

object (ApartmentStatus)

Apartment status

groupname

Group name of constant

Valid values[ "APARTMENT_STATUS" ]

integer

Unique id of constant

list_url

string (url)

Url to fetch all contants from this group

logical_txt

string

Logical textual value

txt

string

Human readable textual representation

Group

object (SnConstants)

groupname

string

Group name of constant. Group name must contain only uppercase letters separated by underscores.

integer

Primary key

num_value

integer

Numerical value of the constant

orderno

integer

Order number

txt

string

Human readable textual representation

txt_2

string

Human readable textual representation

value

string

Logical textual value

Interesting_id

object (SnConstants)

groupname

string

Group name of constant. Group name must contain only uppercase letters separated by underscores.

integer

Primary key

num_value

integer

Numerical value of the constant

orderno

integer

Order number

txt

string

Human readable textual representation

txt_2

string

Human readable textual representation

value

string

Logical textual value

Network_node

integer

Unique Id for water node connected to consumer point

angle

number (float)

Angle rotation of the consumer point object

asbest_ceiling

object (SnConstants)

groupname

string

Group name of constant. Group name must contain only uppercase letters separated by underscores.

integer

Primary key

num_value

integer

Numerical value of the constant

orderno

integer

Order number

txt

string

Human readable textual representation

txt_2

string

Human readable textual representation

value

string

Logical textual value

asbest_corridor

object (SnConstants)

groupname

string

Group name of constant. Group name must contain only uppercase letters separated by underscores.

integer

Primary key

num_value

integer

Numerical value of the constant

orderno

integer

Order number

txt

string

Human readable textual representation

txt_2

string

Human readable textual representation

value

string

Logical textual value

asbest_room

object (SnConstants)

groupname

string

Group name of constant. Group name must contain only uppercase letters separated by underscores.

integer

Primary key

num_value

integer

Numerical value of the constant

orderno

integer

Order number

txt

string

Human readable textual representation

txt_2

string

Human readable textual representation

value

string

Logical textual value

build_year

integer

Build year

comments

string

Remarks

consumer_name

string

Consumer name GDPR protected field

consumer_name_ext

string

Consumer name extension GDPR protected field

consumer_number

string

Water number

cp_state

object (SnConstants)

groupname

string

Group name of constant. Group name must contain only uppercase letters separated by underscores.

integer

Primary key

num_value

integer

Numerical value of the constant

orderno

integer

Order number

txt

string

Human readable textual representation

txt_2

string

Human readable textual representation

value

string

Logical textual value

cp_type

object (SnConstants)

groupname

string

Group name of constant. Group name must contain only uppercase letters separated by underscores.

integer

Primary key

num_value

integer

Numerical value of the constant

orderno

integer

Order number

txt

string

Human readable textual representation

txt_2

string

Human readable textual representation

value

string

Logical textual value

createdBy

string

User that created the object

createdTs

string (date-time)

Creation date and time

critical_customer

object (SnConstants)

groupname

string

Group name of constant. Group name must contain only uppercase letters separated by underscores.

integer

Primary key

num_value

integer

Numerical value of the constant

orderno

integer

Order number

txt

string

Human readable textual representation

txt_2

string

Human readable textual representation

value

string

Logical textual value

critical_customer_remarks

string

Remarks

dh_building_volume

number (float)

District sheating building volume

dh_construction_year

integer

Construction year

dh_dn

object (TxtConstant)

groupname

string

Group name of constant. Same as groupname parameter.

integer

Unique id of constant

logical_txt

string

Logical textual value

txt

string

Human readable textual representation (translated)

dh_limiter

object (TxtConstant)

groupname

string

Group name of constant. Same as groupname parameter.

integer

Unique id of constant

logical_txt

string

Logical textual value

txt

string

Human readable textual representation (translated)

dh_number

string

District heating number

dh_power

number (float)

District heating power

dh_room_count

string

Building / Room count

dh_water_flow

number (float)

District heating water flow

duct_size_dn

object (TxtConstant)

groupname

string

Group name of constant. Same as groupname parameter.

integer

Unique id of constant

logical_txt

string

Logical textual value

txt

string

Human readable textual representation (translated)

elevation

number (float)

Connection elevation value

final_approval_date

string (date-time)

Final approval date

gas_burner_power

integer

Gas burner power

gas_connecting_power

integer

Gas connecting power

gas_device_power

integer

Gas device power

gas_number

string

Gas number

gas_pressure_controller

object (SnConstants)

groupname

string

Group name of constant. Group name must contain only uppercase letters separated by underscores.

integer

Primary key

num_value

integer

Numerical value of the constant

orderno

integer

Order number

txt

string

Human readable textual representation

txt_2

string

Human readable textual representation

value

string

Logical textual value

gas_supply_pressure

integer

Gas supply pressure

gsrn_id

string

GSRN ID

heating_form

object (TxtConstant)

groupname

string

Group name of constant. Same as groupname parameter.

integer

Unique id of constant

logical_txt

string

Logical textual value

txt

string

Human readable textual representation (translated)

hot_water_dim_flow

number (float)

Hot water measurement flow

integer

Primary key

identification

string

Identification name for the consumer point object

industrial_contact_email

string

Industrial contact email GDPR protected field

industrial_contact_info

string

Industrial contact info GDPR protected field

industrial_contact_name

string

Industrial contact name GDPR protected field

industrial_contact_phone

string

Industrial contact number GDPR protected field

industrial_waste_water_contract

object (SnConstants)

groupname

string

Group name of constant. Group name must contain only uppercase letters separated by underscores.

integer

Primary key

num_value

integer

Numerical value of the constant

orderno

integer

Order number

txt

string

Human readable textual representation

txt_2

string

Human readable textual representation

value

string

Logical textual value

joining_date

string (date-time)

Last update date time

location

string (ewkt)

Geographical location

name_extend

string

Consumer name extension

network_number

object (TxtConstant)

groupname

string

Group name of constant. Same as groupname parameter.

integer

Unique id of constant

logical_txt

string

Logical textual value

txt

string

Human readable textual representation (translated)

real_estate_info

string

Real estate info GDPR protected field

real_estate_name

string

Real estate name GDPR protected field

residents

integer

Number of residents

restricted_type

object (TxtConstant)

groupname

string

Group name of constant. Same as groupname parameter.

integer

Unique id of constant

logical_txt

string

Logical textual value

txt

string

Human readable textual representation (translated)

scale

number (float)

Scale of map object

sewer_junction

boolean

Specifies if consumer point is a sewer junction

sprinkler_contact_email

string

Sprinkler contact email GDPR protected field

sprinkler_contact_info

string

Sprinkler contact info GDPR protected field

sprinkler_contact_name

string

Sprinkler contact name GDPR protected field

sprinkler_contact_phone

string

Sprinkler contact number GDPR protected field

sprinkler_customer

object (SnConstants)

groupname

string

Group name of constant. Group name must contain only uppercase letters separated by underscores.

integer

Primary key

num_value

integer

Numerical value of the constant

orderno

integer

Order number

txt

string

Human readable textual representation

txt_2

string

Human readable textual representation

value

string

Logical textual value

storm_water_junction

boolean

Specifies if consumer point is a storm junction

type

object (TxtConstant)

groupname

string

Group name of constant. Same as groupname parameter.

integer

Unique id of constant

logical_txt

string

Logical textual value

txt

string

Human readable textual representation (translated)

updatedBy

string

Last user that updated the record

updatedTs

string (date-time)

Last update date time

water_base_af

string

Water base annual fee

water_db_id

integer

Water database id

water_junction

boolean

Specifies if consumer point is a water junction

Junction

object (Junction)

Address

object (Address)

buildingId

string

Building id

city

string

Building city name

cityAlt

string

Building city name in alternative language

country

string

Building country

createdBy

string

creator

createdTs

string (date-time)

Creation date and time

district

string

Building district

integer

Primary key

location

string (ewkt)

Geographical location

municipality

string

Building municipality

propertyId

string

Property number

province

string

Building province

streetname

string

Building street name

streetnameAlt

string

Building street name in alternative language

streetno

string

Building number

subdivision

string

Building municipality subdivision

updatedBy

string

Last updater

updatedTs

string (date-time)

Last update date time

usagePurpose

object (BuildingUsage)

Building usage purpose

groupname

Group name of constant

Valid values[ "BUILDING_USAGE" ]

integer

Unique id of constant

list_url

string (url)

Url to fetch all contants from this group

logical_txt

string

Logical textual value

txt

string

Human readable textual representation

usagePurposeAlt

object (AddressSecondaryUsage)

Address usage purpose

groupname

Group name of constant

Valid values[ "KN_ADDR_SPEC" ]

integer

Unique id of constant

list_url

string (url)

Url to fetch all contants from this group

logical_txt

string

Logical textual value

txt

string

Human readable textual representation

zipcode

string

Building zipcode

Customer

object (Customer)

Address

object (Address)

buildingId

string

Building id

city

string

Building city name

cityAlt

string

Building city name in alternative language

country

string

Building country

createdBy

string

creator

createdTs

string (date-time)

Creation date and time

district

string

Building district

integer

Primary key

location

string (ewkt)

Geographical location

municipality

string

Building municipality

propertyId

string

Property number

province

string

Building province

streetname

string

Building street name

streetnameAlt

string

Building street name in alternative language

streetno

string

Building number

subdivision

string

Building municipality subdivision

updatedBy

string

Last updater

updatedTs

string (date-time)

Last update date time

usagePurpose

object (BuildingUsage)

Building usage purpose

groupname

Group name of constant

Valid values[ "BUILDING_USAGE" ]

integer

Unique id of constant

list_url

string (url)

Url to fetch all contants from this group

logical_txt

string

Logical textual value

txt

string

Human readable textual representation

usagePurposeAlt

object (AddressSecondaryUsage)

Address usage purpose

groupname

Group name of constant

Valid values[ "KN_ADDR_SPEC" ]

integer

Unique id of constant

list_url

string (url)

Url to fetch all contants from this group

logical_txt

string

Logical textual value

txt

string

Human readable textual representation

zipcode

string

Building zipcode

Customer_language

object (SnConstants)

groupname

string

Group name of constant. Group name must contain only uppercase letters separated by underscores.

integer

Primary key

num_value

integer

Numerical value of the constant

orderno

integer

Order number

txt

string

Human readable textual representation

txt_2

string

Human readable textual representation

value

string

Logical textual value

Customer_restricted_type

object (TxtConstant)

groupname

string

Group name of constant. Same as groupname parameter.

integer

Unique id of constant

logical_txt

string

Logical textual value

txt

string

Human readable textual representation (translated)

Customer_state

object (SnConstants)

groupname

string

Group name of constant. Group name must contain only uppercase letters separated by underscores.

integer

Primary key

num_value

integer

Numerical value of the constant

orderno

integer

Order number

txt

string

Human readable textual representation

txt_2

string

Human readable textual representation

value

string

Logical textual value

Customer_type

object (SnConstants)

groupname

string

Group name of constant. Group name must contain only uppercase letters separated by underscores.

integer

Primary key

num_value

integer

Numerical value of the constant

orderno

integer

Order number

txt

string

Human readable textual representation

txt_2

string

Human readable textual representation

value

string

Logical textual value

Invoicing_address

object (Apartment)

address

object (Address)

buildingId

string

Building id

city

string

Building city name

cityAlt

string

Building city name in alternative language

country

string

Building country

createdBy

string

creator

createdTs

string (date-time)

Creation date and time

district

string

Building district

integer

Primary key

location

string (ewkt)

Geographical location

municipality

string

Building municipality

propertyId

string

Property number

province

string

Building province

streetname

string

Building street name

streetnameAlt

string

Building street name in alternative language

streetno

string

Building number

subdivision

string

Building municipality subdivision

updatedBy

string

Last updater

updatedTs

string (date-time)

Last update date time

usagePurpose

object (BuildingUsage)

Building usage purpose

groupname

Group name of constant

Valid values[ "BUILDING_USAGE" ]

integer

Unique id of constant

list_url

string (url)

Url to fetch all contants from this group

logical_txt

string

Logical textual value

txt

string

Human readable textual representation

usagePurposeAlt

object (AddressSecondaryUsage)

Address usage purpose

groupname

Group name of constant

Valid values[ "KN_ADDR_SPEC" ]

integer

Unique id of constant

list_url

string (url)

Url to fetch all contants from this group

logical_txt

string

Logical textual value

txt

string

Human readable textual representation

zipcode

string

Building zipcode

apartmentDivision

string

apartment division

apartmentLetter

string

apartment letter

apartmentNumber

string

apartment number

integer

Primary key

originProperty

string

apartment original property id

originalStreetno

string

apartment original streen number

usagePurpose

object (ApartmentUsage)

Apartment Usage purpose

groupname

Group name of constant

Valid values[ "APARTMENT_USAGE" ]

integer

Unique id of constant

list_url

string (url)

Url to fetch all contants from this group

logical_txt

string

Logical textual value

txt

string

Human readable textual representation

usagePurposeAlt

object (AddressSecondaryUsage)

Address usage purpose

groupname

Group name of constant

Valid values[ "KN_ADDR_SPEC" ]

integer

Unique id of constant

list_url

string (url)

Url to fetch all contants from this group

logical_txt

string

Logical textual value

txt

string

Human readable textual representation

usageState

object (ApartmentStatus)

Apartment status

groupname

Group name of constant

Valid values[ "APARTMENT_STATUS" ]

integer

Unique id of constant

list_url

string (url)

Url to fetch all contants from this group

logical_txt

string

Logical textual value

txt

string

Human readable textual representation

coop_date

string (date)

Cooperative date

coop_member

boolean

If customer is a member of cooperative or not

coop_reimburse_date

string (date)

Cooperative date of reimbursement

coop_sum

integer

Sum of cooperative

customer_country

string

Customer country

customer_email

string

Customer email address GDPR protected field

customer_name

string

Name of customer GDPR protected field

customer_name_ext

string

Customer name extension GDPR protected field

customer_number

string

Customer number

customer_phone

string

Primary phone number GDPR protected field

edited_by_customer_timestamp

string (date-time)

Customer modified date and time

integer

Primary key

identification

string

Identification of customer

invoicing_country

string

Invoicing country

invoicing_name

string

Invoice name GDPR protected field

is_edited_by_customer

boolean

If editable by customer

no_sms

boolean

If true sms sending is disabled otherwise, it is enabled

note

string

Customer note or additional details

phone2

string

Secondary phone number GDPR protected field

two_sms_numbers

boolean

If using two SMS numbers or not

vat_code

string

Personal/Business ID GDPR protected field

water_db_id

integer

Water database id

Maint_area

object (TxtConstant)

groupname

string

Group name of constant. Same as groupname parameter.

integer

Unique id of constant

logical_txt

string

Logical textual value

txt

string

Human readable textual representation (translated)

Network

object (TxtConstant)

groupname

string

Group name of constant. Same as groupname parameter.

integer

Unique id of constant

logical_txt

string

Logical textual value

txt

string

Human readable textual representation (translated)

State

object (TxtConstant)

groupname

string

Group name of constant. Same as groupname parameter.

integer

Unique id of constant

logical_txt

string

Logical textual value

txt

string

Human readable textual representation (translated)

agreed_delivery

string (date)

Agreed delivery date

building_room

string

Building or room

comments

string

Comments or additional details

connectivity_date

string (date)

Connectivity date

contact_date

string (date)

Contact date

contact_person1

string

First contact person

contact_person2

string

Second contact person

date_created

string (date)

Created date

integer

Primary key

junction_number

string

Junction number

junction_power

number (float)

Junction power

name

string

Name

offer_accepted

boolean

Specifies if offer is accepted

offer_accepted_date

string (date)

Offer accepting date

offer_rejected

boolean

Specifies if offer is rejected

offer_requested

boolean

Specifies if offer is requested

offer_send_date

string (date)

Offer sending date

offer_valid_until_date

string (date)

Offer valid until date

proposed_delivery

string (date)

Proposed delivery date

requested_delivery

string (date)

Requested delivery date

restricted_type

object (TxtConstant)

groupname

string

Group name of constant. Same as groupname parameter.

integer

Unique id of constant

logical_txt

string

Logical textual value

txt

string

Human readable textual representation (translated)

starting_date

string (date)

Starting date

integer

Primary key

Total

integer

Total number of junction connections objects in the list

401

Authentication credentials are missing or invalid

{
  "details": "Authentication credentials were not provided"
}

object

details

string

Detailed description of error

Was this article helpful?

What's Next

Create new Junctions Connections