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));
}
}
}
}
-
Refresh the caller datasource of a form from class Sometime, we have requirement that after completion of the certain process we need to re...
-
Connect postman with Dynamics 365 finance and operation Azure application registration First we need to register application on the azure po...
-
Counting journal is used to modify the on hand inventory of an item with dimension wise. you can create it from Inventory management / Jour...
-
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 ...
-
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...
-
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...
-
public static void main( Args _args) { CustTable custTable; MenuItemMessageAction mes...
-
This is quite common requirement we receive that we need to import the data using data entity with the x++. so to Import the data using dat...
-
void lookup(FormStringControl _control) { SysTableLookup tableLookup = SysTableLookup::newParameters(tableNum(EntAssetObjectTa...