Share
Report
2Hi,
I am new to D365 F&O. Could you please guide me on the task below?
Q: How to pull API data into in x++?
Code:
class GetAPIClient
{
public static str callExternalAPI(str url)
{
System.Net.Http.HttpClient httpClient;
System.Net.Http.HttpResponseMessage responseMessage;
str responseData;
{
public static str callExternalAPI(str url)
{
System.Net.Http.HttpClient httpClient;
System.Net.Http.HttpResponseMessage responseMessage;
str responseData;
// Initialize the HttpClient
httpClient = new System.Net.Http.HttpClient();
// Set a timeout for the HTTP client (e.g., 30 seconds)
httpClient.Timeout = new System.TimeSpan(0, 0, 30);
httpClient = new System.Net.Http.HttpClient();
// Set a timeout for the HTTP client (e.g., 30 seconds)
httpClient.Timeout = new System.TimeSpan(0, 0, 30);
try
{
// Send the GET request
responseMessage = httpClient.GetAsync(url).Result;
{
// Send the GET request
responseMessage = httpClient.GetAsync(url).Result;
// Ensure the request was successful
responseMessage.EnsureSuccessStatusCode();
responseMessage.EnsureSuccessStatusCode();
// Read the response content
responseData = responseMessage.Content.ReadAsStringAsync().Result;
}
catch (Exception::CLRError)
{
// Handle any errors that occur during the request
ClrObject clrEx = ClrInterop::getLastException();
error(strFmt("API call failed: %1", clrEx.ToString()));
responseData = responseMessage.Content.ReadAsStringAsync().Result;
}
catch (Exception::CLRError)
{
// Handle any errors that occur during the request
ClrObject clrEx = ClrInterop::getLastException();
error(strFmt("API call failed: %1", clrEx.ToString()));
// Log additional details
error(strFmt("Exception Type: %1", clrEx.GetType().ToString()));
error(strFmt("Exception Message: %1", clrEx.Message()));
error(strFmt("Exception Type: %1", clrEx.GetType().ToString()));
error(strFmt("Exception Message: %1", clrEx.Message()));
throw error(strFmt("API call failed with exception: %1 - %2", clrEx.GetType().ToString(), clrEx.Message()));
}
finally
{
// Dispose of the HttpClient
httpClient.Dispose();
}
}
finally
{
// Dispose of the HttpClient
httpClient.Dispose();
}
return responseData;
}
}
public static void main(Args _args)
{
try
{
str result = GetAPIClient::callExternalAPI("https://api.restful-api.dev/objects/7");
info("API Response: " + result);
{
try
{
str result = GetAPIClient::callExternalAPI("https://api.restful-api.dev/objects/7");
info("API Response: " + result);
// Parse the JSON response using CLRInterop
System.Type jObjectType = CLRInterop::getType("Newtonsoft.Json.Linq.JObject");
System.Object jObject = jObjectType.getMethod("Parse").Invoke(null, [result]);
info("Parsed JSON successfully.");
System.Type jObjectType = CLRInterop::getType("Newtonsoft.Json.Linq.JObject");
System.Object jObject = jObjectType.getMethod("Parse").Invoke(null, [result]);
info("Parsed JSON successfully.");
// Extract the 'name' property
str name = CLRInterop::getAnyTypeForObject(jObjectType.getMethod("get_Item").Invoke(jObject, ["name"])).ToString();
info("Name: " + name);
str name = CLRInterop::getAnyTypeForObject(jObjectType.getMethod("get_Item").Invoke(jObject, ["name"])).ToString();
info("Name: " + name);
// Extract 'data' object
System.Object dataObject = jObjectType.getMethod("get_Item").Invoke(jObject, ["data"]);
info("Data object extracted.");
System.Object dataObject = jObjectType.getMethod("get_Item").Invoke(jObject, ["data"]);
info("Data object extracted.");
// Extract individual properties from 'data'
int year = CLRInterop::getAnyTypeForObject(dataObject.GetType().getMethod("get_Item").Invoke(dataObject, ["year"]));
real price = CLRInterop::getAnyTypeForObject(dataObject.GetType().getMethod("get_Item").Invoke(dataObject, ["price"]));
str cpuModel = CLRInterop::getAnyTypeForObject(dataObject.GetType().getMethod("get_Item").Invoke(dataObject, ["CPU model"])).ToString();
str hardDiskSize = CLRInterop::getAnyTypeForObject(dataObject.GetType().getMethod("get_Item").Invoke(dataObject, ["Hard disk size"])).ToString();
info(strFmt("Year: %1, Price: %2, CPU Model: %3, Hard Disk Size: %4", year, price, cpuModel, hardDiskSize));
int year = CLRInterop::getAnyTypeForObject(dataObject.GetType().getMethod("get_Item").Invoke(dataObject, ["year"]));
real price = CLRInterop::getAnyTypeForObject(dataObject.GetType().getMethod("get_Item").Invoke(dataObject, ["price"]));
str cpuModel = CLRInterop::getAnyTypeForObject(dataObject.GetType().getMethod("get_Item").Invoke(dataObject, ["CPU model"])).ToString();
str hardDiskSize = CLRInterop::getAnyTypeForObject(dataObject.GetType().getMethod("get_Item").Invoke(dataObject, ["Hard disk size"])).ToString();
info(strFmt("Year: %1, Price: %2, CPU Model: %3, Hard Disk Size: %4", year, price, cpuModel, hardDiskSize));
APIData apiData;
// ttsBegin;
apiData.clear();
apiData.Name = name;
apiData.Year = year;
apiData.Price = price;
apiData.CpuModel = cpuModel;
apiData.HardDiskSize = hardDiskSize;
apiData.insert();
// ttsCommit;
info("Data inserted successfully.");
}
catch (Exception::CLRError)
{
ClrObject clrEx = ClrInterop::getLastException();
error(strFmt("API call failed in main method: %1", clrEx.ToString()));
}
}
}
catch (Exception::CLRError)
{
ClrObject clrEx = ClrInterop::getLastException();
error(strFmt("API call failed in main method: %1", clrEx.ToString()));
}
}
}
All responses (
Answers (
