Finance | Project Operations, Human Resources, ...

Answered

How to consume CRM API GET Method in X++

(0) Share

Report

Posted on by PK mishra

115

I have CRM API with URL & Authentication (Bearer Token) , In Postman App , I successfully get the Response with the GET method.

I need same thing to implement in X , for this I written below code , but Its not working .

static void AXCRMGET(Args _args)
{
        int                                                      find;
        str                                                      url,aosUri,activeDirectoryTenant;
        str                                                      activeDirectoryClientAppId;
        str                                                      activeDirectoryClientAppSecret;
        str                                                      postData,activeDirectoryResource;
        str                                                      aadClientAppSecret,oAuthHeader;
        str                                                      returnValue,jsonString,jsondszstr, byteTokenStr;
        System.Net.HttpWebRequest                                request;
        System.Net.HttpWebResponse                               response;
        System.IO.Stream                                         dataStream;
        System.IO.StreamReader                                   streamRead;
        System.IO.StreamWriter                                   streamWrite;
        System.Net.ServicePoint                                  servicePoint;
        System.Net.ServicePointManager                           servicePointmgr;
        System.Net.HttpVersion                                   version;
        CLRObject                                                clrObj;
        Newtonsoft.Json.JsonReader                               reader;
        System.Text.Encoding                                     utf8;
        Counter                                                  countCounter;
        Object                                                   obj;
        Map                                                      data;
        System.Byte[]                                            byteArraynew;
        System.Byte[]                                            byteArray, byteArrayToken;


        System.Net.WebHeaderCollection headers = new System.Net.WebHeaderCollection();

        str  token  = "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsIng1dCI6ImpTMVhvMU9XRGpfNTJ2YndHTmd2UU8yVnpNYyIsImtpZCI6ImpTMVhvMU9XRGpfNTJ2YndHTmd2UU8yVnpNYyJ9.eyJhdWQiOiJodHRwczovL2JpYW1wZGV2LmNybS5keW5hbWljcy5jb20vIiwiaXNzIjoiaHR0cHM6Ly9zdHMud2luZG93cy5uZXQvMzQxYWM1NzItMDY2Yy00NmY2LWJmMDYtYjJkMGM3ZGRmMWJlLyIsImlhdCI6MTY0NzQ5MjA3NiwibmJmIjoxNjQ3NDkyMDc2LCJleHAiOjE2NDc0OTYxNzYsImFjciI6IjEiLCJhaW8iOiJFMlpnWURpZzJWeGR6M2wrcGR6V2gxRmNFZE00MXF3L1BFZDlrWmlQbHZ6VSt1WS9VWThCIiwiYW1yIjpbInB3ZCJdLCJhcHBpZCI6IjJhZDg4Mzk1LWI3N2QtNDU2MS05NDQxLWQwZTQwODI0ZjliYyIsImFwcGlkYWNyIjoiMCIsImZhbWlseV9uYW1lIjoiVmlqYXlha3VtYXIiLCJnaXZlbl9uYW1lIjoiWW9nZXNoIiwiaXBhZGRyIjoiMTA2LjIwOC4xNDkuMTUzIiwibmFtZSI6IllvZ2VzaCBWaWpheWFrdW1hciIsIm9pZCI6IjYyMmFlZDE0LTllNGQtNDIwNy1hMTAzLWY1OTNlYjE0ZWRlMyIsIm9ucHJlbV9zaWQiOiJTLTEtNS0yMS0xMjYyNjQ0ODk0LTE3MDY1MjMyMDItMTUzODg4MjI4MS0yNzkwMCIsInB1aWQiOiIxMDAzMjAwMTRFNTdFOTIxIiwicmgiOiIwLkFVVUFjc1VhTkd3RzlrYV9CckxReDkzeHZnY0FBQUFBQUFBQXdBQUFBQUFBQUFCRkFKWS4iLCJzY3AiOiJ1c2VyX2ltcGVyc29uYXRpb24iLCJzdWIiOiJ4c0o3Ui0wellYMG4yUUpSTGlHRmp4c2liSTJpTFNQT2FFcFpmWTRvb3I0IiwidGlkIjoiMzQxYWM1NzItMDY2Yy00NmY2LWJmMDYtYjJkMGM3ZGRmMWJlIiwidW5pcXVlX25hbWUiOiJ5b2dlc2gudmlqYXlha3VtYXJAYmlhbXAuY29tIiwidXBuIjoieW9nZXNoLnZpamF5YWt1bWFyQGJpYW1wLmNvbSIsInV0aSI6IkZzd2toZkU4VDBXeFpSMnl3VWttQUEiLCJ2ZXIiOiIxLjAiLCJ3aWRzIjpbImI3OWZiZjRkLTNlZjktNDY4OS04MTQzLTc2YjE5NGU4NTUwOSJdfQ.f2OITp-rof2Ifar2Nn9BMzhh0J9AvAwA5daoQDP0SXGQ8F8Vm44-lVEWw6ZhCCSGQokeRZaj57fD8GU4Yjotobzn6uSQkHa8UCgeo9OiwysLvCJ9souy3w0Oxre_RK59oV2DaN8k13WDZ4TJlaXHdwlFzR1z5ufLzXmYwX5kRVdpnNqi4U-TAmdjnF3WC40lwuVn4GuSggupvwowywEOK3TnBEwUbIdqt2ZEcmaCpoA6KZUoahDVXBZIeQPn82buywhH-GldDoFqNFm3WPuQJwlHmJysIl9i8q5RlDuHuQsPBLgH3CB5Qul-mMvelMqFzvADzPFr-s2fBP9xBp8F4w";

        new InteropPermission(InteropKind::ClrInterop).assert();

        headers = new System.Net.WebHeaderCollection();

        url = "https://biampdev.api.crm.dynamics.com/api/data/v9.1/quotes?$filter=quotenumber eq 'QUO-04041-N6Y0'";

        clrObj = System.Net.WebRequest::Create(url);


        request = clrObj;
        request.set_Method("GET");
        request.set_KeepAlive(true);

        request.set_ContentType("application/json");
        utf8    = System.Text.Encoding::get_UTF8();

        byteArrayToken = utf8.GetBytes(token);
        byteTokenStr = System.Convert::ToBase64String(byteArrayToken);

        headers.Add("Authorization", strfmt("bearer %1", byteTokenStr));


        request.set_Headers(headers);

        servicePoint = request.get_ServicePoint();

        System.Net.ServicePointManager::set_Expect100Continue(false);

        System.Net.ServicePointManager::set_SecurityProtocol(System.Net.SecurityProtocolType::Tls12);

        response = request.GetResponse();

        info(any2str(response));

        dataStream = response.GetResponseStream();


        streamRead = new System.IO.StreamReader(dataStream);

        jsonString = streamRead.ReadToEnd();

        info(strFmt("%1",jsonString));

        dataStream.Close();

        response.Close();
    }

I try to Debug the code , But in Line 62 its automatic Exit from The code .

Kindly Help me, where this code is wrong ? If You Guys have any other code for this requirement ,Then also give me other code.

Thanks

All responses (3)

Answers (1)

Verified answer

Martin Dráb 231,923 Most Valuable Professional on at

Like (0)

Report

RE: How to consume CRM API GET Method in X++

You aren't using the same token as in Postman. You take the took and convert it with Base64, which gives you a different string. What if you actually use the same token (token variable instead of byteArrayToken)?

PK mishra

115 on at

Like (0)

Report

RE: How to consume CRM API GET Method in X++

Hi Martin,

Thanks for reply,

I put Try & Catch block, Then i got message "The remote server returned an error: (401) Unauthorized." as shown by below code.

static void AXCRMGET(Args _args)
{
        int                                                      find;
        str                                                      url,aosUri,activeDirectoryTenant;
        str                                                      activeDirectoryClientAppId;
        str                                                      activeDirectoryClientAppSecret;
        str                                                      postData,activeDirectoryResource;
        str                                                      aadClientAppSecret,oAuthHeader;
        str                                                      returnValue,jsonString,jsondszstr, byteTokenStr;
        System.Net.HttpWebRequest                                request;
        System.Net.HttpWebResponse                               response;
        System.IO.Stream                                         dataStream;
        System.IO.StreamReader                                   streamRead;
        System.IO.StreamWriter                                   streamWrite;
        System.Net.ServicePoint                                  servicePoint;
        System.Net.ServicePointManager                           servicePointmgr;
        System.Net.HttpVersion                                   version;
        CLRObject                                                clrObj;
        Newtonsoft.Json.JsonReader                               reader;
        System.Text.Encoding                                     utf8;
        Counter                                                  countCounter;
        Object                                                   obj;
        Map                                                      data;
        System.Byte[]                                            byteArraynew;
        System.Byte[]                                            byteArray, byteArrayToken;
    
    
        System.Net.WebHeaderCollection headers = new System.Net.WebHeaderCollection();    
        

        str  token  = "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsIng1dCI6ImpTMVhvMU9XRGpfNTJ2YndHTmd2UU8yVnpNYyIsImtpZCI6ImpTMVhvMU9XRGpfNTJ2YndHTmd2UU8yVnpNYyJ9.eyJhdWQiOiJodHRwczovL2JpYW1wZGV2LmNybS5keW5hbWljcy5jb20vIiwiaXNzIjoiaHR0cHM6Ly9zdHMud2luZG93cy5uZXQvMzQxYWM1NzItMDY2Yy00NmY2LWJmMDYtYjJkMGM3ZGRmMWJlLyIsImlhdCI6MTY0NzUxMDUzNSwibmJmIjoxNjQ3NTEwNTM1LCJleHAiOjE2NDc1MTQ4NjEsImFjciI6IjEiLCJhaW8iOiJFMlpnWU5oOFY5WHBqbkNxeVBkUFNmcU0yaVluVEI5ZThaZGNMTEg1bitXcUM5MTZWaG9BIiwiYW1yIjpbInB3ZCJdLCJhcHBpZCI6IjJhZDg4Mzk1LWI3N2QtNDU2MS05NDQxLWQwZTQwODI0ZjliYyIsImFwcGlkYWNyIjoiMCIsImZhbWlseV9uYW1lIjoiVmlqYXlha3VtYXIiLCJnaXZlbl9uYW1lIjoiWW9nZXNoIiwiaXBhZGRyIjoiMTA2LjIwOC4xNTEuNDkiLCJuYW1lIjoiWW9nZXNoIFZpamF5YWt1bWFyIiwib2lkIjoiNjIyYWVkMTQtOWU0ZC00MjA3LWExMDMtZjU5M2ViMTRlZGUzIiwib25wcmVtX3NpZCI6IlMtMS01LTIxLTEyNjI2NDQ4OTQtMTcwNjUyMzIwMi0xNTM4ODgyMjgxLTI3OTAwIiwicHVpZCI6IjEwMDMyMDAxNEU1N0U5MjEiLCJyaCI6IjAuQVVVQWNzVWFOR3dHOWthX0JyTFF4OTN4dmdjQUFBQUFBQUFBd0FBQUFBQUFBQUJGQUpZLiIsInNjcCI6InVzZXJfaW1wZXJzb25hdGlvbiIsInN1YiI6InhzSjdSLTB6WVgwbjJRSlJMaUdGanhzaWJJMmlMU1BPYUVwWmZZNG9vcjQiLCJ0aWQiOiIzNDFhYzU3Mi0wNjZjLTQ2ZjYtYmYwNi1iMmQwYzdkZGYxYmUiLCJ1bmlxdWVfbmFtZSI6InlvZ2VzaC52aWpheWFrdW1hckBiaWFtcC5jb20iLCJ1cG4iOiJ5b2dlc2gudmlqYXlha3VtYXJAYmlhbXAuY29tIiwidXRpIjoiUVhqeV9RVlJ0RUMtN2VOLUZsSlJBQSIsInZlciI6IjEuMCIsIndpZHMiOlsiYjc5ZmJmNGQtM2VmOS00Njg5LTgxNDMtNzZiMTk0ZTg1NTA5Il19.k5a2v9Uzv9QSRm5kiBuS8aeRPGBLZZP7ZKZrCAYQRnNi9x7BeFcrUVn1czQ9qW6ZwzhqJvrK-Ak63KO9vv9x1lUT4hjblTRopEme7HYyW6kfHCz82Zht3Zr0FoGfWF2sGNjiHUjvUcEg2HhStjVTrZIaLUq0dNLWzHA9vjYJP8Uj1KIJi1QmNhWoJ91m-Hg6YtmjPlTKPeAjz7KK_fFrkjpWm-L4SEQjegqc17L5Hgea8ggQUfksXHC1SYxvYnGAPVyl5pFI2FZvDhrOvdT23LJitLv-bLWJeQZjGNQsvIUfvhFxPSG5hXAOg-_b4h8CRyyUPSgcYyidPXMXj38axw";

        new InteropPermission(InteropKind::ClrInterop).assert();

        headers = new System.Net.WebHeaderCollection();

        url = "https://biampdev.api.crm.dynamics.com/api/data/v9.1/quotes?$filter=quotenumber eq 'QUO-04041-N6Y0'";

    try{    
        
        clrObj = System.Net.WebRequest::Create(url);


        request = clrObj;
        request.set_Method("GET");
        request.set_KeepAlive(true);

        request.set_ContentType("application/json");
        utf8    = System.Text.Encoding::get_UTF8();

        byteArrayToken = utf8.GetBytes(token);
        byteTokenStr = System.Convert::ToBase64String(byteArrayToken);

        headers.Add("Authorization", strfmt("bearer %1", byteTokenStr));


        request.set_Headers(headers);

        servicePoint = request.get_ServicePoint();

        System.Net.ServicePointManager::set_Expect100Continue(false);

        System.Net.ServicePointManager::set_SecurityProtocol(System.Net.SecurityProtocolType::Tls12);

        response = request.GetResponse();

        info(any2str(response));

        dataStream = response.GetResponseStream();


        streamRead = new System.IO.StreamReader(dataStream);

        jsonString = streamRead.ReadToEnd();

        info(strFmt("%1",jsonString));

        dataStream.Close();

        response.Close();
    }
    catch (Exception::CLRError)
    {
    throw error(AifUtil::getClrErrorMessage());
    }
 }

I putted same token in postman, Please see my code & Postman Authorization & Param settings. Where I making mistake.

Thanks

Martin Dráb 231,923 Most Valuable Professional on at

Like (1)

Report
RE: How to consume CRM API GET Method in X++

All right, so you're getting an unhandled exception at line 62, but you have no information about the exception because you forgot to catch it. Do something like this:

try { ... } catch (Exception::CLRError) { throw error(AifUtil::getClrErrorMessage()); }

We can get more details from the exception if needed, but this is a good start.

Community site session details

How to consume CRM API GET Method in X++

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

Announcing Our 2025 Season 1 Super Users!

Kudos to the February Top 10 Community Stars!

Leaderboard

Featured topics

Product updates

Community site session details

How to consume CRM API GET Method in X++

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

Announcing Our 2025 Season 1 Super Users!

Kudos to the February Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates