Power Platform Community Forum Thread Details

Hello I'm trying to build a Powerapp that is connected with a Custom Connector to the Bing Location by Query API to implement a autocomplete Feature for adresses . The following json is what comes back from the API. (I've limited the maxResults to 2 for Overview. So far everything works fine.

{
 "authenticationResultCode": "ValidCredentials",
 "brandLogoUri": "http://dev.virtualearth.net/Branding/logo_powered_by.png",
 "copyright": "Copyright © 2020 Microsoft and its suppliers. All rights reserved. This API cannot be accessed and the content and any results may not be used, reproduced or transmitted in any manner without express written permission from Microsoft Corporation.",
 "resourceSets": [
 {
 "estimatedTotal": 2,
 "resources": [
 {
 "__type": "Location:http://schemas.microsoft.com/search/local/ws/rest/v1",
 "bbox": [
 42.221472282630124,
 -91.9173596561078,
 42.229197717771477,
 -91.903450343926181
 ],
 "name": "55th Street Dr, Urbana, IA 52349",
 "point": {
 "type": "Point",
 "coordinates": [
 42.2253350002008,
 -91.910405000017
 ]
 },
 "address": {
 "addressLine": "55th Street Dr",
 "adminDistrict": "IA",
 "adminDistrict2": "Benton County",
 "countryRegion": "United States",
 "formattedAddress": "55th Street Dr, Urbana, IA 52349",
 "locality": "Urbana",
 "postalCode": "52349"
 },
 "confidence": "Medium",
 "entityType": "RoadBlock",
 "geocodePoints": [
 {
 "type": "Point",
 "coordinates": [
 42.2253350002008,
 -91.910405000017
 ],
 "calculationMethod": "Interpolation",
 "usageTypes": [
 "Display"
 ]
 }
 ],
 "matchCodes": [
 "Ambiguous"
 ],
 "queryParseValues": [
 {
 "property": "AddressLine",
 "value": "55th street"
 }
 ]
 },
 {
 "__type": "Location:http://schemas.microsoft.com/search/local/ws/rest/v1",
 "bbox": [
 42.221260829189724,
 -91.930334457410382,
 42.228986264331077,
 -91.916425191809608
 ],
 "name": "55th Street Dr, Vinton, IA 52349",
 "point": {
 "type": "Point",
 "coordinates": [
 42.2251235467604,
 -91.92337982461
 ]
 },
 "address": {
 "addressLine": "55th Street Dr",
 "adminDistrict": "IA",
 "adminDistrict2": "Benton County",
 "countryRegion": "United States",
 "formattedAddress": "55th Street Dr, Vinton, IA 52349",
 "locality": "Vinton",
 "postalCode": "52349"
 },
 "confidence": "Medium",
 "entityType": "RoadBlock",
 "geocodePoints": [
 {
 "type": "Point",
 "coordinates": [
 42.2251235467604,
 -91.92337982461
 ],
 "calculationMethod": "Interpolation",
 "usageTypes": [
 "Display"
 ]
 }
 ],
 "matchCodes": [
 "Ambiguous"
 ],
 "queryParseValues": [
 {
 "property": "AddressLine",
 "value": "55th street"
 }
 ]
 }
 ]
 }
 ],
 "statusCode": 200,
 "statusDescription": "OK",
 "traceId": "6054522a30434ed5ab32d69f743a312e|DU00000D59|0.0.0.1|Ref A: 34A1FF39582147659D0AB5B6445FF55B Ref B: DB3EDGE1015 Ref C: 2020-08-03T12:17:57Z"
}

The Problem I encounter is now that I only can acess the following properties of the Connector in the Powerapp: "authenticationResultCode", "brandLogoUri", "copyright", "resourceSets"(but only this, I can't expand further to "resource"), "estimatetTotal", "statusCode", "statusDescription" and "traceId". The properties I would need are "name" and the "point"-Array. I know it would be possible to drill the whole thing through a flow, but this isn't an option for me because of performance. (Who wants to wait a minute on a flow for autocomplete). Can anyone of you help me solve this problem or is this not solvable with powerapps?

Categories:

Building Power Apps