Power automate - cloud flow send files to BC SaaS

Damjan
Member Posts: 94
Hi All,
My client is running BC SaaS (latest version V19) and some records from 3rd party cloud solution are being send into the BC SaaS via cloud flow that I designed in the Power Automate. I am looking at blob storage module in BC for potential solution of recieving files via cloud flow. Is this going to work?
Goal to achieve is this:
As cloud flow is triggered, a record is first received (get) in that 3rd party cloud applications' database where also all of the linked files are being archived into the *.ZIP file format (this is done on-the-fly) and that *.ZIP file is then send with that record to BC SaaS.
My solution is to create new table ("Employee Attachment") and link that table with T5200 - "Employee" and as BC receives record via cloud flow and as that record is commited in T5200 - Employee, that *.ZIP file will be inserted in new table ("Employee Attachment") in field: "Attachment" (blob datatype).
User then click on a button Employee Attachments on Page Employee where this attached file will be placed and user will download the file to his local computer.
I saw that BC version 15 supports blob storage module, I guess this should work. Right?
Another question - are these files (*.ZIP) calculated in the storage quota of BC SaaS license?
Do you think this will work?
Thanks Damjan
My client is running BC SaaS (latest version V19) and some records from 3rd party cloud solution are being send into the BC SaaS via cloud flow that I designed in the Power Automate. I am looking at blob storage module in BC for potential solution of recieving files via cloud flow. Is this going to work?
Goal to achieve is this:
As cloud flow is triggered, a record is first received (get) in that 3rd party cloud applications' database where also all of the linked files are being archived into the *.ZIP file format (this is done on-the-fly) and that *.ZIP file is then send with that record to BC SaaS.
My solution is to create new table ("Employee Attachment") and link that table with T5200 - "Employee" and as BC receives record via cloud flow and as that record is commited in T5200 - Employee, that *.ZIP file will be inserted in new table ("Employee Attachment") in field: "Attachment" (blob datatype).
User then click on a button Employee Attachments on Page Employee where this attached file will be placed and user will download the file to his local computer.
I saw that BC version 15 supports blob storage module, I guess this should work. Right?
Another question - are these files (*.ZIP) calculated in the storage quota of BC SaaS license?
Do you think this will work?
Thanks Damjan
0
Best Answer
-
Alright, I see...
Our DB is huge and we tried to avoid at any cost storing some additional blobs in the cloud, we are very limited there, that`s why... Not completely sure about licensing cost for Azure Blob though.0
Answers
-
Not sure if it is a good idea to store all those blobs directly in a BC SaaS table.
Wouldn`t you consider using AzureBlob instead?0 -
Hi,
those data are just documents (pdfs, docx) files compressed in ZIP archive, so there should not be more then 400 MB per year.
I would like to avoid additional costs with license for Azure Blob Storage...0 -
Alright, I see...
Our DB is huge and we tried to avoid at any cost storing some additional blobs in the cloud, we are very limited there, that`s why... Not completely sure about licensing cost for Azure Blob though.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions