SELECT *
FROM #Request.prefix_db_lookup#.pPhysicians
WHERE Status =
AND Phys_NPI = 1578637229
GROUP BY Phys_NPI
UPDATE #Request.prefix_db_lookup#.pPhysicians
SET Phys_verified = 0 WHERE status = 0
// Define the base API URL
baseURL = "https://npiregistry.cms.hhs.gov/api/";
// Define the query parameters
parameters = {
number = getsphy.Phys_NPI,
enumeration_type = "",
taxonomy_description = "",
name_purpose = "",
first_name = "",
use_first_name_alias = "",
last_name = "",
organization_name = "",
address_purpose = "",
city = "",
state = "",
postal_code = "",
country_code = "",
limit = "",
skip = "",
pretty = "",
version = "2.1"
};
// Convert parameters to query string
queryString = "";
for (param in parameters) {
// if (len(parameters[param]) > 0) {
queryString &= param & "=" & urlEncodedFormat(parameters[param]) & "&";
//}
}
if (right(queryString, 1) == "&") {
queryString = left(queryString, len(queryString) - 1);
}
// Construct the full URL
fullURL = baseURL & "?" & queryString;
fullURL = lcase(fullURL);
// Make the HTTP GET request using cfhttp
cfhttp(
url = fullURL,
method = "get",
result = "response"
,charset = "utf-8"
);
writedump (fullURL);
// Check the response status code
if (response.statusCode == 200) {
responseData = deserializeJSON(response.fileContent);
if (isDefined("responseData.result_count"))
if (responseData.result_count gt 0)
{
session.Phys_NPIs = listAppend(session.Phys_NPIs, getsphy.Phys_NPI);
}
} else {
writedump (response);
writeOutput("Error fetching data for NPI: " & getsphy.Phys_NPI & "
");
writeOutput("Status Code: " & response.statusCode & "
");
//writeOutput("Status Text: " & response.statusText & "
");
}
UPDATE #Request.prefix_db_lookup#.pPhysicians
SET Phys_verified = 1
WHERE Phys_NPI IN (#session.Phys_NPIs#)
AND status = 0