D365 FO - Data Entity (Azure AD & Postman Access Token)

 Problem Statement: 

            How to get the D365FO Access Token via POSTMAN.


Steps: 

    1. visit https://portal.azure.com/ (For Active Directory Authentication) 
    2. Go to Azure Active Directory >> App Registration >>  New Registrations >> Fill the Following Details.
    3. After Complete the Registration following details will display in the registration section.


    4. Go to the "Certificates & Secrets" >> New Client Secrets. Refer the below attachment.


    5. Open the POSTMAN.
      Collection >> New Collection >> Add Request.(Get Token is a Request name.)
    6. Use the following URI in the "GET" method.
      "https://login.microsoftonline.com/{TenantID}.
      Note : Tenant ID :- Taken this ID from the Azure registration section.  
    7. POSTMAN Body section.
       Body >> Form-data >> enter the following key-values.
            

    8. Access Token will generate after hit the Send button.


    9. After getting the access token, we need to map the client id via D365FO front end.
      D365FO >> System Administration >> Setup >> Azure Active Directory Applications.
      >>New/Edit >> {Client Id} >>  and Map the "admin user" under the "User_ID" Section and click the Save button.



    10. If you want to get the list of OData entity is available in the D365FO, you need to type the following URL in the browser.
      "https://D365FOURL/data"
      data.json file automatically downloaded.
    11. Open the file and search your custom entity is available in the Json file.
    12. After found your custom entity name and type the following URL in the browser again.
      "https://D365FOURL/data/{CustomEntityName}"
      customentity.json file automatically downloaded, Save and open the file.
    13. File has contain the List of all the data against the entity.

      Another Way for Access the D365FO Data:

    14. We can access the same data via POST Man also.
    15. Open the POSTMAN.
      Add Request.(Get the entity value as a Request name.) >> Get Method >>"https://D365FOURL/data/{CustomEntityName}" 
    16. Header >> "Content-Type" as a Key and "application/json" as a value.
    17. authorization >> Type >> Bearer Token >> Token >> "Copy  the Access token value form the Step # 8 and paste it here".
    18. Hit the send button from postman.
    19. List of all the data against the entity.
      Note : Some scenario need to disable the "SSL Certificate".
    20. If you want to Insert / Update. Needs to pass the JSON in the Body section and change the Method as "POST" and hit the send button.
    21. Based on your value records are insert or updated in the system.

Comments

Post a Comment

Popular posts from this blog

DMF (1073676279) - Issue Fix

 Problem Statement:      When  I tried to Import the data via DMF I got the following error message. <?xml version="1.0"?><Errors><Error><ErrorCode>-2146233088</ErrorCode><SubComponent>Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper</SubComponent><Description>DMF2060 -    at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFXmlPackageImport.AddDataFlowComponent(Package _Package)    at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFPackageControllerImport.CreateAndExecutePackage()    at DMFExecutePackage.PackageCreator.processEntity()    at DMFExecutePackage.Program.Main(String[] args)</Description></Error><Error><ErrorCode>-1073676279</ErrorCode><SubComponent>Microsoft.SqlServer.DTSPipelineWrap</SubComponent><Description>Exception from HRESULT: 0xC0010009 -    at Microsoft.SqlServer.Dts.Pipeline.Wra...
Read more

Read the JSON data via REST API (X++)

  Problem Statement:           Read the data from outside Application. Here I am fetch the JSON data from Shopify Integration and push it in to the D365FO System.   Development steps:       Step 1 : Create Runnable Class.      Step 2 : After create the Runnable class, use the following Library in your solution.                               using System.Net.HttpWebRequest;                               using System.Net.HttpWebResponse;                               using System.Text.Json;                               using System.Text.Json.Serialization;  ...
Read more

Activate Financial Dimension in Dynamics 365 FO. (On- Premises)

  If you want to activate the financial dimension in Dynamics 365 on on-premises, you need to do a following step. 1.      Open SQL and go to D365FO Database. 2.     Execute the following Query                   select * from SQLSYSTEMVARIABLES         update SQLSYSTEMVARIABLES SET VALUE = 1 WHERE PARM =                     'CONFIGURATIONMODE' 3.      Execute IIS Restart. 4.     Refresh the Page. 5.     After activating the financial dimension, you need to revert the option.              update SQLSYSTEMVARIABLES SET VALUE = 0 WHERE PARM                     =   'CONFIGURATIONMODE' 6.    Execute IIS Restart. 7.    Refresh the Page.
Read more