Finance | Project Operations, Human Resources, ...

Find Existing Blob Storage for D365 FO

(0) Share

Report

Posted on by Pouyan

Hello everyone

I want to find the connection string of our production D365 FO existing blob storage which store all the attachments and files. I see some people can find it via Azure Storage Explorer but for some reason that I dont know, we cant see it (I am not sure what Subscription its using or what user has access to it). Also, I have a admin access so it shouldnt be a privilege problem.

Can I find the current attached blob storage info (like connection string, subscription, etc) somewhere?

I appreciate if help me.

thanks

I have the same question (0)

All responses (20)

Answers (0)

André Arnaud de Cal... 300,915 Super User 2025 Season 2 on at

Like (1)

Report

Hi Pouyan,

Can you tell what you want to achieve? What would be the purpose of knowing the connection string? The storage is linked to and managed via the Dynamics 365 application. You can't manage individual user access.

Was this reply helpful? Yes No
Pouyan 10 on at

Like (0)

Report

The final goal is to download all the attachments which are stored in the Blob storage. We investigate all possible options (AOT, Export Job) and I think the best way, faster and more reliable way to get all the attachments (to archive them) is to connect to the Blob then just download the container and have it in our storage. (I can map the GUID with the names later)

Was this reply helpful? Yes No
Sukrut Parab 71,710 Moderator on at

Like (0)

Report

You can see it through storage explorer only for tier 1 environments not for Tier 2. Also storage explorer will give you view where you can see GUID as filename. You will have to loop through docuValue table in F&O and get the document from blob using FIleID and download it.

Was this reply helpful? Yes No
Pouyan 10 on at

Like (0)

Report

So, how can I understand which tier we are using? we need to extract the files out of the production (its tier 1 or 2)

Was this reply helpful? Yes No
Sukrut Parab 71,710 Moderator on at

Like (1)

Report

Off course production is not tier 1 so you cant use storage explorer option. Not sure how may documents you have but look at the standard feature on document attachment form where when you click open button it downloads attachment for you and build your own script for downloading all document. Be aware this may not work if you have huge number of attachments. There are other options you can think of like create your own storage and copy those from F&O blob to your own storage and then download through storage explorer.

Was this reply helpful? Yes No
Pouyan 10 on at

Like (0)

Report

so exactly we have huge amount of documents around 82000. so I dont think I can use the first option.

but how we can copy the files to our blob storage?

Do you mean that screen shot? System administration > Setup > System parameters > Data connections

or it sth else

Was this reply helpful? Yes No
Pouyan 10 on at

Like (0)

Report

so it doesnt mean if I want to copy the F&O blob to my blob storage, first I need to connect to the existing blob (by SAS or connection string) then copy it? so I think I need to find the connection string of the current blob.... where is it and how can I get that?

Was this reply helpful? Yes No
André Arnaud de Cal... 300,915 Super User 2025 Season 2 on at

Like (0)

Report

For security reasons, you can't get a SAS or connection string for the BLOB storage. You would need data entities or coding top copy the files from the BLOB storage to another storage account.

Was this reply helpful? Yes No
Pouyan 10 on at

Like (0)

Report

yes but if at least you need to get the "Connection string" and the "Key" to connect to the source and copy it to another blob,,,,

How I can get those OR Can I do this through the API and copy everything to another Blob? I got this:

dynamicsaxtechnicalstuff.blogspot.com/.../part-1-connect-azure-blob-storage-with.html

dynamicsaxtechnicalstuff.blogspot.com/.../part-2-connect-azure-blob-storage-with.html

dynamicsaxtechnicalstuff.blogspot.com/.../part-3-connect-azure-blob-storage-with.html

dynamicsaxtechnicalstuff.blogspot.com/.../part-4-connect-azure-blob-storage-with.html

and

community.dynamics.com/.../attachements-in-d365-f-o

But for all the recommended solutions, you need to connect to the source blob with a key (or its in your Azure subscription) but we cant find the key and nor we can see the blob through the storage explorer and azure portal

SO I NEED TO FIND THE KEY OR CONNECTION STRING OF MY CURRENT BLOB

Was this reply helpful? Yes No
Sukrut Parab 71,710 Moderator on at

Like (1)

Report

The blog series you posted is about reading file from storage account created in Azure. First part talks about how to create storage account and in later parts its explained how to use x++ code to read file from there.

If you create storage account in Azure, you will get key to access it. This storage account is different than blob associated with F&O environment.

For production environment you are not going to get any key to connect to it, so you could get files from it by using x++ code/ available API's within F&O and copy it your storage account.

Was this reply helpful? Yes No