Dynamics Community Forum Thread Details

Hi,

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;

// 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);

try
{
// Send the GET request
responseMessage = httpClient.GetAsync(url).Result;

// Ensure the request was successful
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()));

// Log additional details
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();
}

return responseData;
}

public static void main(Args _args)
{
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.");

// Extract the 'name' property
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.");

// 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));

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()));
}
}

}

Community site session details

Pull API json data into in x++

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Andrés Arias – Community Spotlight

Congratulations to the August Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates