url /entity_set_name
Abrufen aller Daten in der Entitätsgruppe.
Request:
https://company-talend-com.eu.talend-dataset.com/apis/customers-api-2PZPTB/customers
Code in die Zwischenablage kopieren
Antwort:
{
"@odata.context": "http://company-talend-com.eu.talend-dataset.com/apis/customers-api-2PZPTB/$metadata#customers",
"value": [
{
"customer_age": "36",
"id": "g9wjC",
"customer_name": "Franklin Washington",
"customer_city": "Olympia",
"customer_street": "North Erringer Road"
},
{
"customer_age": "31",
"id": "DNOFp",
"customer_name": "Theodore Ford",
"customer_city": "Boise",
"customer_street": "Lawrenceville Suwanee"
},
{
"customer_age": "41",
"id": "IRvgp",
"customer_name": "Gerald Cleveland",
"customer_city": "Atlanta",
"customer_street": "Steele Lane"
},
{
"customer_age": "19",
"id": "V7o2h",
"customer_name": "Benjamin Adams",
"customer_city": "Little Rock",
"customer_street": "Castillo Drive"
},
{
"customer_age": "56",
"id": "LwvLC",
"customer_name": "Theodore Hayes",
"customer_city": "Saint Paul",
"customer_street": "Carpinteria South"
},
{
"customer_age": "22",
"id": "2oWSU",
"customer_name": "Harry Roosevelt",
"customer_city": "Bismarck",
"customer_street": "East Calle Primera"
},
{
"customer_age": "68",
"id": "tnXgw",
"customer_name": "Rutherford Fillmore",
"customer_city": "Cheyenne",
"customer_street": "Jean de la Fontaine"
}
]
}
Code in die Zwischenablage kopieren
url /$metadata
Abrufen der Metadaten der Entitätsgruppe.
Request:
https://company-talend-com.eu.talend-dataset.com/apis/customers-api-2PZPTB/$metadata
Code in die Zwischenablage kopieren
Antwort:
<?xml version="1.0" encoding="UTF-8" ?>
< edmx: Edmx Version = " 4.0" xmlns: edmx= " http://docs.oasis-open.org/odata/ns/edmx" >
< edmx: DataServices>
< Schema xmlns = " http://docs.oasis-open.org/odata/ns/edm" Namespace = " customers-api-2PZPTB" >
< EntityType Name = " customersItem" >
< Key>
< PropertyRef Name = " id" />
</ Key>
< Property Name = " customer_age" Type = " Edm.String" />
< Property Name = " id" Type = " Edm.String" />
< Property Name = " customer_name" Type = " Edm.String" />
< Property Name = " customer_city" Type = " Edm.String" />
< Property Name = " customer_street" Type = " Edm.String" />
</ EntityType>
< EntityContainer Name = " customers" >
< EntitySet Name = " customers" EntityType = " customers-api-2PZPTB.customersItem" />
</ EntityContainer>
</ Schema>
</ edmx: DataServices>
</ edmx: Edmx>
Code in die Zwischenablage kopieren
url /entity_set_name (primary_key_value )
Abrufen einer spezifischen Entität über den entsprechenden Primärschlüsselwert.
Request:
https://company-talend-com.eu.talend-dataset.com/apis/customers-api-2PZPTB/customers('g9wjC')
Code in die Zwischenablage kopieren Antwort:{
"@odata.context": "http://company-talend-com.eu.talend-dataset.com/apis/customers-api-2PZPTB/$metadata#customers",
"customer_age": "36",
"id": "g9wjC",
"customer_name": "Franklin Washington",
"customer_city": "Olympia",
"customer_street": "North Erringer Road"
}
Code in die Zwischenablage kopieren
url /entity_set_name (primary_key_value )/column_name
Abrufen einer einzelnen Spalte für eine bestimmte Entität.
Request:
https://company-talend-com.eu.talend-dataset.com/apis/customers-api-2PZPTB/customers('g9wjC')/customer_name
Code in die Zwischenablage kopieren
Antwort:
{
"@odata.context": "http://company-talend-com.eu.talend-dataset.com/apis/customers-api-2PZPTB/$metadata#customers/customer_name",
"value": "Franklin Washington"
}
Code in die Zwischenablage kopieren
url /entity_set_name (primary_key_value )/column_name /$value
Abrufen des Rohwerts einer Spalte für eine bestimmte Entität.
Request:
https://company-talend-com.eu.talend-dataset.com/apis/customers-api-2PZPTB/customers('g9wjC')/customer_city/$value
Code in die Zwischenablage kopieren
Antwort:
Olympia
Code in die Zwischenablage kopieren
url /entity_set_name ?$top=n
Abrufen einer begrenzten Anzahl von Entitäten
Request:
https://company-talend-com.eu.talend-dataset.com/apis/customers-api-2PZPTB/customers?$top=2
Code in die Zwischenablage kopieren
Antwort:
{
"@odata.context": "http://company-talend-com.eu.talend-dataset.com/apis/customers-api-2PZPTB/$metadata#customers",
"value": [
{
"customer_age": "36",
"id": "g9wjC",
"customer_name": "Franklin Washington",
"customer_city": "Olympia",
"customer_street": "North Erringer Road"
},
{
"customer_age": "31",
"id": "DNOFp",
"customer_name": "Theodore Ford",
"customer_city": "Boise",
"customer_street": "Lawrenceville Suwanee"
}
]
}
Code in die Zwischenablage kopieren
url /entity_set_name ?$skip=n
Abrufen einer Sammlung von Entitäten, wobei die ersten n Entitäten übersprungen werden.
Request:
https://company-talend-com.eu.talend-dataset.com/apis/customers-api-2PZPTB/customers?$skip=5
Code in die Zwischenablage kopieren
Antwort:
{
"@odata.context": "http://company-talend-com.eu.talend-dataset.com/apis/customers-api-2PZPTB/$metadata#customers",
"value":[
{
"customer_age": "22",
"id": "2oWSU",
"customer_name": "Harry Roosevelt",
"customer_city": "Bismarck",
"customer_street": "East Calle Primera"
},
{
"customer_age": "68",
"id": "tnXgw",
"customer_name": "Rutherford Fillmore",
"customer_city": "Cheyenne",
"customer_street": "Jean de la Fontaine"
},
{
"customer_age": "40",
"id": "QcX7L",
"customer_name": "Warren Adams",
"customer_city": "Columbus",
"customer_street": "North Broadway Street"
}
]
}
Code in die Zwischenablage kopieren
url /entity_set_name ?$skip=n &$top=n
Erstellen einer Seitennummerierung und Abrufen einer spezifischen Entitätsseite aus einer Sammlung.
Request:
https://company-talend-com.eu.talend-dataset.com/apis/customers-api-2PZPTB/customers?$skip=5&$top=2
Code in die Zwischenablage kopieren
Antwort:
{
"@odata.context": "http://company-talend-com.eu.talend-dataset.com/apis/customers-api-2PZPTB/$metadata#customers",
"value": [
{
"customer_age": "22",
"id": "2oWSU",
"customer_name": "Harry Roosevelt",
"customer_city": "Bismarck",
"customer_street": "East Calle Primera"
},
{
"customer_age": "68",
"id": "tnXgw",
"customer_name": "Rutherford Fillmore",
"customer_city": "Cheyenne",
"customer_street": "Jean de la Fontaine"
}
]
}
Code in die Zwischenablage kopieren
url /entity_set_name ?$select=column_name
Abrufen ausschließlich bestimmter Entitätsattribute.Informationshinweis Anmerkung: Die als Primärschlüssel verwendete Spalte wird immer einbezogen.
Request:
https://company-talend-com.eu.talend-dataset.com/apis/customers-api-2PZPTB/customers?$select=customer_city,customer_street
Code in die Zwischenablage kopieren
Antwort:
{
"@odata.context": "http://company-talend-com.eu.talend-dataset.com/apis/customers-api-2PZPTB/$metadata#customers",
"value": [
{
"@odata.id": "customers('g9wjC')",
"id": "g9wjC",
"customer_city": "Olympia",
"customer_street": "North Erringer Road"
},
{
"@odata.id": "customers('DNOFp')",
"id": "DNOFp",
"customer_city": "Boise",
"customer_street": "Lawrenceville Suwanee"
},
{
"@odata.id": "customers('IRvgp')",
"id": "IRvgp",
"customer_city": "Atlanta",
"customer_street": "Steele Lane"
}
]
}
Code in die Zwischenablage kopieren
url /entity_set_name ?$orderby=column_name asc|desc
Abrufen einer Sammlung von Entitäten in einer bestimmten Reihenfolge unter Verwendung eines oder mehrerer Attribute. Zwei mögliche Werte für diese Option: asc (aufst.) und desc (abst.).
Request:
https://company-talend-com.eu.talend-dataset.com/apis/customers-api-2PZPTB/customers?$orderby=customer_age desc
Code in die Zwischenablage kopieren
Antwort:
{
"@odata.context": "http://company-talend-com.eu.talend-dataset.com/apis/customers-api-2PZPTB/$metadata#customers",
"value": [
{
"customer_age": "78",
"id": "2lxMe",
"customer_name": "Thomas Johnson",
"customer_city": "Charleston",
"customer_street": "Redwood Highway"
},
{
"customer_age": "75",
"id": "EK0fU",
"customer_name": "Benjamin Jefferson",
"customer_city": "Austin",
"customer_street": "Monroe Street"
},
{
"customer_age": "70",
"id": "3Wmih",
"customer_name": "Grover Carter",
"customer_city": "Dover",
"customer_street": "Redwood Highway"
}
]
}
Code in die Zwischenablage kopieren
url /entity_set_name ?$filter=column_name eq 'value '
Abrufen einer Sammlung von Entitäten gemäß einem Filter.
Request:
https://company-talend-com.eu.talend-dataset.com/apis/customers-api-2PZPTB/customers?$filter=customer_city eq 'Olympia'
Code in die Zwischenablage kopieren
Antwort:
{
"@odata.context": "http://company-talend-com.eu.talend-dataset.com/apis/customers-api-2PZPTB/$metadata#customers",
"value":[
{
"customer_age": "36",
"id": "g9wjC",
"customer_name": "Franklin Washington",
"customer_city": "Olympia",
"customer_street": "North Erringer Road"
},
{
"customer_age": "68",
"id": "EVFMD",
"customer_name": "Ronald Van Buren",
"customer_city": "Olympia",
"customer_street": "Bayshore Freeway"
}
]
}
Code in die Zwischenablage kopieren
Informationshinweis Anmerkung: Je nachdem, welches Tool für den Aufruf der API verwendet wird, erhalten Sie unter Umständen einen Fehler, wenn Leerstellen mit Pluszeichen (+ ) kodiert werden. Um dieses Problem zu vermeiden, müssen Sie sicherstellen, dass Leerstellen in der Prozentkodierung als %20 kodiert werden.
url /entity_set_name ?$filter=contains(column_name , 'value' )
Abrufen einer Sammlung von Entitäten gemäß einem Filter, wobei column_name einen bestimmten Wert ('value' ) enthält.
Request:
https://company-talend-com.eu.talend-dataset.com/apis/customers-api-2PZPTB/customers?$filter=contains(customer_name, 'Van')
Code in die Zwischenablage kopieren
Antwort:
{
"@odata.context": "http://company-talend-com.eu.talend-dataset.com/apis/customers-api-2PZPTB/$metadata#customers",
"value":[
{
"customer_age": "68",
"id": "EVFMD",
"customer_name": "Ronald Van Buren",
"customer_city": "Olympia",
"customer_street": "Bayshore Freeway"
}
]
}
Code in die Zwischenablage kopieren