Thursday, August 22, 2024

Package import api through postman

 Scenario:-Importing a data package through postman

Step1:-Create a import project in d365fo 

Note:- Add a Sample file in add file section

Step2:-Go to postman generate bearer token 

Get :-https://login.microsoftonline.com/tenantid/oauth2/token 

 

Body:- formdata 

 

a) tenant_id  

b) client_id –  

c) client_secret –  
d) grant_type – client_credentials 
e) resource – enter D365FO environment URL (note it should not end with /) 

 

Output:- 

{ 

    "token_type""Bearer", 

    "expires_in""3599", 

    "ext_expires_in""3599", 

    "expires_on""1723463000", 

    "not_before""1723459100", 

    "access_token""eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsIng1dCI6IktRMnRBY3JFN2xCYVZWR0JtYzVGb2JnZEpvNCIsImtpZCI6IktRMnRBY3JFN2xCYVZWR0JtYzVGb2JnZEpvNCJ9.eyJhdWQiOiJodHRwczovL3RyaWFsLXpwZ3l2ay50cmlhbC5vcGVyYXRpb25zLmR5bmFtaWNzLmNvbS8iLCJpc3MiOiJodHRwczovL3N0cy53aW5kb3dzLm5ldC9jYTA2YTExMC1mYzMwLTQ3ZTUtOWRkNC03MThkNWQ0YzQyNDQvIiwiaWF0IjoxNzIzNDU5MTAwLCJuYmYiOjE3MjM0NTkxMDAsImV4cCI6MTcyMzQ2MzAwMCwiYWlvIjoiRTJkZ1lEaW5WelN6T2o1LzZaSHN2Y212UHA0eEFnQT0iLCJhcHBpZCI6IjQ5ZjAxNWI5LWQ1MzMtNDdlNi1iYTI2LTc3MGZlMTU3Y2NjMyIsImFwcGlkYWNyIjoiMSIsImlkcCI6Imh0dHBzOi8vc3RzLndpbmRvd3MubmV0L2NhMDZhMTEwLWZjMzAtNDdlNS05ZGQ0LTcxOGQ1ZDRjNDI0NC8iLCJpZHR5cCI6ImFwcCIsIm9pZCI6IjYyNGE1MDBiLTk3ODItNDk1ZC1hMWQ1LTc4YTNkYTg2MTg2OSIsInJoIjoiMC5BU29BRUtFR3lqRDg1VWVkMUhHTlhVeENSQlVBQUFBQUFBQUF3QUFBQUFBQUFBQXFBQUEuIiwic3ViIjoiNjI0YTUwMGItOTc4Mi00OTVkLWExZDUtNzhhM2RhODYxODY5IiwidGlkIjoiY2EwNmExMTAtZmMzMC00N2U1LTlkZDQtNzE4ZDVkNGM0MjQ0IiwidXRpIjoiZXdQWWU3S2hoVXllS0dURGgtS1VBQSIsInZlciI6IjEuMCIsInhtc19pZHJlbCI6IjcgMiJ9.kNDAndZRZgwN-78gPl3aSHW-A7am5hSALHrqDJpwJBITgXePf2BtbqkyMYV6H_T_vlCp2nCymEFrSbJJFihGQ1f5xiuth9vjLasSm1sH5mK2Gr8t7Y78YEdjYnABI0NIIrHBug__aEGdB-eAd7zBmI_rZ9f1ca4UBHxlrjskZCB6hoEjO44v0_eisWTwU5o6no6GI8ZrpAbDiNkqpiZMwwfh6JJfm9SQwq1k_rTFhyGQ8lg19zofxy4l29IMw4-kwTqQYN5_JeEiZCxVbsJ2WjUJpLzKNpabyDe859Vr9HQe1MwSAZHfgvvPF3020po9hrhznewHkOGmKKOGZyzrNQ" 

} 

Step3:-Now use getazurewriteurl Api to get a URL path to store file

Post :-https://trial-zpgyvk.trial.operations.dynamics.com/data/DataManagementDefinitionGroups/Microsoft.Dynamics.DataEntities.GetAzureWriteUrl

Body:-

{
    "uniqueFileName":"mani"
}
In authorization choose bearer token and give bearer token which is generated in previous step

Step4:-In response you will get a URL link generated paste this URL in next request

Put:-https://trlzpgyvkzjh1xw76.blob.core.windows.net/dmf/mani?sv=2018-03-28&sr=b&sig=A060QGzIDoohhx0zpe50yJp%2FXBtbyMcjPWgFZGi63wQ%3D&st=2024-08-22T06%3A57%3A00Z&se=2024-08-22T07%3A32%3A00Z&sp=rw

Note:- In headers add x-ms-blob-type -BlockBlob

In body in binary upload file

after send request you will just created message with no content

Step5:-Now use import from package URL

Post:-https://trial-zpgyvk.trial.operations.dynamics.com/data/DataManagementDefinitionGroups/Microsoft.Dynamics.DataEntities.ImportFromPackage

Body:-

{
    "packageUrl":"https://trlzpgyvkzjh1xw76.blob.core.windows.net/dmf/mani?sv=2018-03-28&sr=b&sig=A060QGzIDoohhx0zpe50yJp%2FXBtbyMcjPWgFZGi63wQ%3D&st=2024-08-22T06%3A57%3A00Z&se=2024-08-22T07%3A32%3A00Z&sp=rw",
    "definitionGroupId":"thursdayimportproject",
    "executionId":"",
    "execute":true,
    "overwrite":true,
    "legalEntityId":"USMF"
}
Note :- In authorization choose bearer token and paste bearer token and In headers add
1)x-ms-blob-type -BlockBlob
2)Authorization -long generated bearertoken

Once you send request go to d365fo and see new records inserted or not

Step6:-Open d365fo and go to customer groups

Keep Daxing!!





No comments:

Post a Comment

Upload File from local system in a form

 Actions to be done at 3 stages  1) Create Fileupload item by right clicking on design as shown in image below 2)Change Properties especiall...