In these blogs you will get some technical information about Dynamics 365 Finance and operation, AX 2012, Power Platform and from SQL, Azure logic apps.
Search This Blog
Tuesday, August 23, 2022
How to create label or label file in Dynamics 365 Finance and Operation
Monday, August 1, 2022
Create lookup method using x++ in Dynamics 365 FO
void lookup(FormStringControl _control)
{
SysTableLookup tableLookup = SysTableLookup::newParameters(tableNum(EntAssetObjectTable), _control);
Query query = new Query();
QueryBuildDataSource qbdsAssetTable = query.addDataSource(tableNum(EntAssetObjectTable));
tableLookup.parmQuery(query);
tableLookup.addLookupfield(fieldNum(EntAssetObjectTable, SerialID));
tableLookup.addLookupfield(fieldNum(EntAssetObjectTable, ObjectID));
tableLookup.addLookupfield(fieldNum(EntAssetObjectTable, Name));
tableLookup.performFormLookup();
}
Friday, July 1, 2022
How to download file from Azure Blob using x++ in D365 FO
Create the storage account on the azure as per below and copy the keys to connect to this storage account.
Create a container inside this storage account named with dynamicsfocontainer. We can upload the files from our local directory. To download the files from blob container we can use the below code in the x++. Below is the runnable class that I have developed.
You can use the exception as per your requirement and loop as well.
using Microsoft.WindowsAzure.Storage;
using Microsoft.WindowsAzure.Storage.Blob;
internal final class CreateReadWriteBlobStorage
{
/// <summary>
/// Class entry point. The system will call this method
when a designated menu
/// is selected or when execution starts and this class
is set as the startup class.
/// </summary>
/// <param name = "_args">The specified
arguments.</param>
public static void main(Args _args)
{
CloudStorageAccount storageAccount;
CloudBlobContainer blobContainer;
CloudBlobClient blobClient;
storageAccount =
CloudStorageAccount::Parse("DefaultEndpointsProtocol=https;AccountName=dynamicsfinanceoperation;AccountKey=I1IFZ7bdzX61466bAxbNChJVN3PbtUgPfNH5WbXbnc8sTIXS/ffZmN0EDo+zbS+AStn3n0Pw==;EndpointSuffix=core.windows.net");
blobClient =
storageAccount.CreateCloudBlobClient();
blobContainer =
blobClient.GetContainerReference("dynamicsfocontainer");
System.Collections.IEnumerable listEnumerable = blobContainer.ListBlobs(null,true,0,null,null);
System.Collections.IEnumerator listEnumerator =
listEnumerable.GetEnumerator();
while (listEnumerator.MoveNext())
{
IListBlobItem item =
listEnumerator.Current;
if (item is CloudBlockBlob)
{
CloudBlockBlob blockBlob = item;
System.IO.FileStream
localFile = System.IO.File::Create(@"C:\Temp\Blob\" + blockBlob.Name);
blockBlob.DownloadToStreamAsync(localFile);
Info(strFmt("%1",blockBlob.Name));
}
}
}
}
-
Connect postman with Dynamics 365 finance and operation Azure application registration First we need to register application on the azure po...
-
Refresh the caller datasource of a form from class Sometime, we have requirement that after completion of the certain process we need to re...
-
Some time we get the below error during the database synchronization in AX 2012. There could be many solution for this error Check all the ...
-
Counting journal is used to modify the on hand inventory of an item with dimension wise. you can create it from Inventory management / Jour...
-
Creating a csv file using x++ in AX 2012 R3. To create a csv file as we have different - different classed can be used. CommaIO - Output wi...
-
This is how method will execute when record will be created from DIXF using data entity. It also includes the methods related to tables as w...
-
void lookup(FormStringControl _control) { SysTableLookup tableLookup = SysTableLookup::newParameters(tableNum(EntAssetObjectTa...
-
public static void main( Args _args) { CustTable custTable; MenuItemMessageAction mes...
-
How to read excel file using x++ in Dynamics 365 Finance and operation Below is the Runnable class we can use to read the excel file. inte...
-
Create the storage account on the azure as per below and copy the keys to connect to this storage account. Create a container inside this s...