web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

How to consume CRM API GET Method in X++

(0) ShareShare
ReportReport
Posted on by 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 

I have the same question (0)
  • Martin Dráb Profile Picture
    236,320 Most Valuable Professional on at
    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.

  • PK mishra Profile Picture
    115 on at
    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

  • Verified answer
    Martin Dráb Profile Picture
    236,320 Most Valuable Professional on at
    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)?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

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

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,047

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 885 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 592 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans