My PVA flow stopped working because there has been changes to the API.
I adjusted the API and now I can connect to it again but I cannot get the information out. See adjusted API below.
A while ago I had the same issue. I posted it and got a solution, it worked but now I cannot seem to replicate this. The API has changed and I do not know how to get at the following items:
This was my original post which I got a solution for.
Solved: Re: HTTP Request - Parse JSON Results - Power Platform Community (microsoft.com)
What I am trying to do is get certain information from this API. See below...
NPPES NPI Registry (hhs.gov)
This is the results of "John Smith"
{
"result_count": 10,
"results": [
{
"created_epoch": "1514904344000",
"enumeration_type": "NPI-1",
"last_updated_epoch": "1514904344000",
"number": "1316454283",
"addresses": [
{
"country_code": "US",
"country_name": "United States",
"address_purpose": "MAILING",
"address_type": "DOM",
"address_1": "365 MALACCA ST",
"city": "AKRON",
"state": "OH",
"postal_code": "443053659"
},
{
"country_code": "US",
"country_name": "United States",
"address_purpose": "LOCATION",
"address_type": "DOM",
"address_1": "339 E GLENWOOD AVE",
"city": "AKRON",
"state": "OH",
"postal_code": "443103850",
"telephone_number": "330-957-4599"
}
],
"practiceLocations": [],
"basic": {
"first_name": "JOHN",
"last_name": "SMITH",
"sole_proprietor": "YES",
"gender": "M",
"enumeration_date": "2018-01-02",
"last_updated": "2018-01-02",
"status": "A",
"name_prefix": "Mr."
},
"taxonomies": [
{
"code": "1744G0900X",
"taxonomy_group": "",
"desc": "Specialist, Graphics Designer",
"state": null,
"license": null,
"primary": false
},
{
"code": "251V00000X",
"taxonomy_group": "",
"desc": "Voluntary or Charitable",
"state": null,
"license": null,
"primary": false
},
{
"code": "344600000X",
"taxonomy_group": "",
"desc": "Taxi",
"state": null,
"license": null,
"primary": false
},
{
"code": "172A00000X",
"taxonomy_group": "",
"desc": "Driver",
"state": "OH",
"license": "sm821261",
"primary": true
}
],
"identifiers": [],
"endpoints": [],
"other_names": []
},
{
"created_epoch": "1167937023000",
"enumeration_type": "NPI-1",
"last_updated_epoch": "1401988163000",
"number": "1225185168",
"addresses": [
{
"country_code": "US",
"country_name": "United States",
"address_purpose": "MAILING",
"address_type": "DOM",
"address_1": "3455 WHIPPLE AVE NW",
"city": "CANTON",
"state": "OH",
"postal_code": "447183034",
"telephone_number": "330-492-7889",
"fax_number": "330-492-7966"
},
{
"country_code": "US",
"country_name": "United States",
"address_purpose": "LOCATION",
"address_type": "DOM",
"address_1": "3455 WHIPPLE AVE NW",
"city": "CANTON",
"state": "OH",
"postal_code": "447183034",
"telephone_number": "330-492-7889",
"fax_number": "330-492-7966"
}
],
"practiceLocations": [],
"basic": {
"first_name": "JOHN",
"last_name": "SMITH",
"middle_name": "DALE",
"credential": "D.D.S.",
"sole_proprietor": "NO",
"gender": "M",
"enumeration_date": "2007-01-04",
"last_updated": "2014-06-05",
"status": "A",
"name_prefix": "Dr.",
"name_suffix": "--"
},
"taxonomies": [
{
"code": "1223G0001X",
"taxonomy_group": "",
"desc": "Dentist, General Practice",
"state": "OH",
"license": "30-02-0412",
"primary": true
}
],
"identifiers": [],
"endpoints": [],
"other_names": []
},
{
"created_epoch": "1326139852000",
"enumeration_type": "NPI-1",
"last_updated_epoch": "1326139852000",
"number": "1477823342",
"addresses": [
{
"country_code": "US",
"country_name": "United States",
"address_purpose": "MAILING",
"address_type": "DOM",
"address_1": "415 W GUY AVE",
"city": "PAULS VALLEY",
"state": "OK",
"postal_code": "730753200",
"telephone_number": "405-238-1170"
},
{
"country_code": "US",
"country_name": "United States",
"address_purpose": "LOCATION",
"address_type": "DOM",
"address_1": "415 W GUY AVE",
"city": "PAULS VALLEY",
"state": "OK",
"postal_code": "730753200",
"telephone_number": "405-238-1170"
}
],
"practiceLocations": [],
"basic": {
"first_name": "JONATHAN",
"last_name": "SMITH",
"middle_name": "JAMES",
"credential": "PA-C",
"sole_proprietor": "NO",
"gender": "M",
"enumeration_date": "2012-01-09",
"last_updated": "2012-01-09",
"status": "A",
"name_prefix": "--",
"name_suffix": "--"
},
"taxonomies": [
{
"code": "363AM0700X",
"taxonomy_group": "",
"desc": "Physician Assistant, Medical",
"state": "OK",
"license": "2096",
"primary": true
}
],
"identifiers": [],
"endpoints": [],
"other_names": []
},
{
"created_epoch": "1326257206000",
"enumeration_type": "NPI-1",
"last_updated_epoch": "1549727400000",
"number": "1205106036",
"addresses": [
{
"country_code": "US",
"country_name": "United States",
"address_purpose": "LOCATION",
"address_type": "DOM",
"address_1": "275 SHERATON BLVD STE 100",
"city": "MACON",
"state": "GA",
"postal_code": "312101359",
"telephone_number": "478-745-5779"
},
{
"country_code": "US",
"country_name": "United States",
"address_purpose": "MAILING",
"address_type": "DOM",
"address_1": "275 SHERATON BLVD",
"address_2": "STE 100",
"city": "MACON",
"state": "GA",
"postal_code": "312101359",
"telephone_number": "478-745-5779"
}
],
"practiceLocations": [],
"basic": {
"first_name": "JOHN",
"last_name": "SMITH",
"middle_name": "DIXON",
"credential": "PA-C",
"sole_proprietor": "NO",
"gender": "M",
"enumeration_date": "2012-01-10",
"last_updated": "2019-02-09",
"status": "A"
},
"taxonomies": [
{
"code": "363A00000X",
"taxonomy_group": "",
"desc": "Physician Assistant",
"state": "GA",
"license": "6348",
"primary": true
}
],
"identifiers": [],
"endpoints": [],
"other_names": []
},
{
"created_epoch": "1294785034000",
"enumeration_type": "NPI-1",
"last_updated_epoch": "1294785034000",
"number": "1114222809",
"addresses": [
{
"country_code": "US",
"country_name": "United States",
"address_purpose": "MAILING",
"address_type": "DOM",
"address_1": "2301 S EIGHT TRIBES TRL",
"address_2": "PO BOX 1498",
"city": "MIAMI",
"state": "OK",
"postal_code": "743541009",
"telephone_number": "918-542-1655"
},
{
"country_code": "US",
"country_name": "United States",
"address_purpose": "LOCATION",
"address_type": "DOM",
"address_1": "2301 S EIGHT TRIBES TRL",
"city": "MIAMI",
"state": "OK",
"postal_code": "743541009",
"telephone_number": "918-542-1655"
}
],
"practiceLocations": [],
"basic": {
"first_name": "JOHNNY",
"last_name": "SMITH",
"middle_name": "R",
"credential": "RN",
"sole_proprietor": "NO",
"gender": "M",
"enumeration_date": "2011-01-11",
"last_updated": "2011-01-11",
"status": "A",
"name_prefix": "--",
"name_suffix": "--"
},
"taxonomies": [
{
"code": "163WD0400X",
"taxonomy_group": "",
"desc": "Registered Nurse, Diabetes Educator",
"state": "OK",
"license": "R0074090",
"primary": true
}
],
"identifiers": [],
"endpoints": [],
"other_names": []
},
{
"created_epoch": "1168626044000",
"enumeration_type": "NPI-1",
"last_updated_epoch": "1183957886000",
"number": "1306996970",
"addresses": [
{
"country_code": "US",
"country_name": "United States",
"address_purpose": "MAILING",
"address_type": "DOM",
"address_1": "P O DRAWER 30",
"city": "FOREST",
"state": "MS",
"postal_code": "39074",
"telephone_number": "601-469-3851",
"fax_number": "601-469-4356"
},
{
"country_code": "US",
"country_name": "United States",
"address_purpose": "LOCATION",
"address_type": "DOM",
"address_1": "1040 HWY 35 SOUTH",
"city": "FOREST",
"state": "MS",
"postal_code": "39074",
"telephone_number": "601-469-3851",
"fax_number": "601-469-4356"
}
],
"practiceLocations": [],
"basic": {
"first_name": "JOHN",
"last_name": "SMITH",
"middle_name": "B",
"credential": "DMD",
"sole_proprietor": "NO",
"gender": "M",
"enumeration_date": "2007-01-12",
"last_updated": "2007-07-09",
"status": "A",
"name_prefix": "--",
"name_suffix": "Jr."
},
"taxonomies": [
{
"code": "1223G0001X",
"taxonomy_group": "",
"desc": "Dentist, General Practice",
"state": "MS",
"license": "1853",
"primary": true
}
],
"identifiers": [
{
"code": "05",
"desc": "MEDICAID",
"issuer": null,
"identifier": "00064776",
"state": "MS"
}
],
"endpoints": [],
"other_names": []
},
{
"created_epoch": "1547555598000",
"enumeration_type": "NPI-1",
"last_updated_epoch": "1547555598000",
"number": "1215401112",
"addresses": [
{
"country_code": "US",
"country_name": "United States",
"address_purpose": "MAILING",
"address_type": "DOM",
"address_1": "4112 SHIRLEY DR",
"city": "MEMPHIS",
"state": "TN",
"postal_code": "381094600",
"telephone_number": "901-348-9985"
},
{
"country_code": "US",
"country_name": "United States",
"address_purpose": "LOCATION",
"address_type": "DOM",
"address_1": "4112 SHIRLEY DR",
"city": "MEMPHIS",
"state": "TN",
"postal_code": "381094600",
"telephone_number": "901-348-9985"
}
],
"practiceLocations": [],
"basic": {
"first_name": "JONATHAN",
"last_name": "SMITH",
"middle_name": "LANG",
"sole_proprietor": "NO",
"gender": "M",
"enumeration_date": "2019-01-15",
"last_updated": "2019-01-15",
"status": "A"
},
"taxonomies": [
{
"code": "133N00000X",
"taxonomy_group": "",
"desc": "Nutritionist",
"state": null,
"license": null,
"primary": true
}
],
"identifiers": [],
"endpoints": [],
"other_names": []
},
{
"created_epoch": "1137773825000",
"enumeration_type": "NPI-1",
"last_updated_epoch": "1208268066000",
"number": "1144200528",
"addresses": [
{
"country_code": "US",
"country_name": "United States",
"address_purpose": "LOCATION",
"address_type": "DOM",
"address_1": "1715 W MAIN ST",
"city": "HEBER SPRINGS",
"state": "AR",
"postal_code": "725432835",
"telephone_number": "501-362-0606",
"fax_number": "501-362-8842"
},
{
"country_code": "US",
"country_name": "United States",
"address_purpose": "MAILING",
"address_type": "DOM",
"address_1": "10201 KANIS RD",
"city": "LITTLE ROCK",
"state": "AR",
"postal_code": "722056203",
"telephone_number": "501-227-5050",
"fax_number": "501-227-5151"
}
],
"practiceLocations": [],
"basic": {
"first_name": "JOHN",
"last_name": "SMITH",
"middle_name": "THOMAS",
"credential": "MD",
"sole_proprietor": "NO",
"gender": "M",
"enumeration_date": "2006-01-20",
"last_updated": "2008-04-15",
"status": "A",
"name_prefix": "Dr.",
"name_suffix": "--"
},
"taxonomies": [
{
"code": "207Y00000X",
"taxonomy_group": "",
"desc": "Otolaryngology",
"state": "AR",
"license": "C3297",
"primary": true
}
],
"identifiers": [
{
"code": "01",
"desc": "Other (non-Medicare)",
"issuer": "RAILROAD MEDICARE",
"identifier": "040011743",
"state": "AR"
},
{
"code": "05",
"desc": "MEDICAID",
"issuer": null,
"identifier": "104143001",
"state": "AR"
},
{
"code": "08",
"desc": "MEDICARE PIN",
"issuer": null,
"identifier": "54946",
"state": "AR"
},
{
"code": "02",
"desc": "MEDICARE UPIN",
"issuer": null,
"identifier": "E34511",
"state": "AR"
}
],
"endpoints": [],
"other_names": []
},
{
"created_epoch": "1547734628000",
"enumeration_type": "NPI-1",
"last_updated_epoch": "1547734628000",
"number": "1699249250",
"addresses": [
{
"country_code": "US",
"country_name": "United States",
"address_purpose": "MAILING",
"address_type": "DOM",
"address_1": "3995 CARLTON AVE",
"city": "COLUMBUS",
"state": "OH",
"postal_code": "432273604",
"telephone_number": "419-543-8692"
},
{
"country_code": "US",
"country_name": "United States",
"address_purpose": "LOCATION",
"address_type": "DOM",
"address_1": "16 W LONG ST",
"city": "COLUMBUS",
"state": "OH",
"postal_code": "432152815",
"telephone_number": "614-225-0980"
}
],
"practiceLocations": [],
"basic": {
"first_name": "JOHN",
"last_name": "SMITH",
"middle_name": "STEVEN",
"credential": "LPN",
"sole_proprietor": "NO",
"gender": "M",
"enumeration_date": "2019-01-17",
"last_updated": "2019-01-17",
"status": "A"
},
"taxonomies": [
{
"code": "164W00000X",
"taxonomy_group": "",
"desc": "Licensed Practical Nurse",
"state": "OH",
"license": "LPN.166618.MEDS-IV",
"primary": true
}
],
"identifiers": [],
"endpoints": [],
"other_names": []
},
{
"created_epoch": "1137782980000",
"enumeration_type": "NPI-1",
"last_updated_epoch": "1342115275000",
"number": "1538149885",
"addresses": [
{
"country_code": "US",
"country_name": "United States",
"address_purpose": "MAILING",
"address_type": "DOM",
"address_1": "115 WRIGHTS ST",
"address_2": "STE 304",
"city": "HOT SPRINGS",
"state": "AR",
"postal_code": "719136240",
"telephone_number": "501-321-9803",
"fax_number": "501-321-0710"
},
{
"country_code": "US",
"country_name": "United States",
"address_purpose": "LOCATION",
"address_type": "DOM",
"address_1": "115 WRIGHTS ST",
"address_2": "STE 304",
"city": "HOT SPRINGS",
"state": "AR",
"postal_code": "719136240",
"telephone_number": "501-321-9803",
"fax_number": "501-321-0710"
}
],
"practiceLocations": [],
"basic": {
"first_name": "JOHN",
"last_name": "SMITH",
"middle_name": "WAYNE",
"credential": "M.D.",
"sole_proprietor": "NO",
"gender": "M",
"enumeration_date": "2006-01-20",
"last_updated": "2012-07-12",
"status": "A",
"name_prefix": "Dr.",
"name_suffix": "--"
},
"taxonomies": [
{
"code": "207RN0300X",
"taxonomy_group": "",
"desc": "Internal Medicine, Nephrology",
"state": "AR",
"license": "C5929",
"primary": true
}
],
"identifiers": [
{
"code": "05",
"desc": "MEDICAID",
"issuer": null,
"identifier": "110407001",
"state": "AR"
},
{
"code": "08",
"desc": "MEDICARE PIN",
"issuer": null,
"identifier": "54957",
"state": "AR"
},
{
"code": "02",
"desc": "MEDICARE UPIN",
"issuer": null,
"identifier": "D17105",
"state": "AR"
}
],
"endpoints": [],
"other_names": []
}
]
}
This is my flow:
These are the pieces I want from the JSON above.
1. The corresponding number, or NPI number. In this example it is the 1316454283. But keep in mind that multiple individuals might come back.
2. Full name. The full name will be a combination of the last name separated by a comma and first name
3. Practice Site
4. Specialty
I am getting the following error in the select step.
If someone can kindly help I would so much appreciated. I am just struggling with my initial post. I thought I could replicate it easily while implementing the new API but I just do not have much experience in parsing JSON. @Expiscornovus @Pstork1
Thank you for looking at my post again.
