15,428
Hi
Is it possible to read CSV file from Azure Blob then create general journal in Business Central using BC Standard API? I do not mean theoretically or yes it is possible. I mean if someone wrote a blog about it or has some code? By code I mean Azure Logic App code or something like that.
Thanks
Hi Mr Bruvik
You are amazing. Thank you so much for the code. I will try this in our Sandbox and if I run to an issue I will contact you. Please know I really appreciate your help here.
Hi MahGah !
Sorry for the delay.
Here is a very basic code that reads a file from a csv file from a blob storage and creates general journal lines.
github.com/.../GenJorunalImport
So far I only handle 3 fields Account No. Amount and date.
And most of it is hard coded for now and we can move that into a setup.
And it is configured to read a file from my blob storage. You will have to change that to your own blob storage.
You can e-mail me if you want and we can refine it further for your use.
Thanks Nitin Verma your article is really helpful to download/upload file. But I am not sure how to create General Journal here?
Thanks DAnny3211 I tried to use the last 3 links but I get error 404. I can see the logic but still not sure about the code. I mean as a none-programmer it is hard to write the code.
Hi, here is also a simple example, hoping to give you some hints.
https://www.linkedin.com/pulse/business-central-azure-blob-storage-bert-verbeek/
Thanks.
ZHU
Hi,
You can go through my blog, where I am reading, storing, and deleting the file from Blob storage.
hi
it is possible to read a CSV file from Azure Blob and create a general journal in Business Central using the BC Standard API.
There are different ways to achieve this, and it may depend on your specific requirements and setup. However, here are some general steps and resources that could be helpful:
Use Azure Logic Apps or Azure Functions to trigger the process when a new CSV file is uploaded to the Azure Blob Storage. You can use the Blob Storage connector to interact with the storage.
Parse the CSV file to extract the data you need. You can use a CSV connector or a custom code.
Use the Business Central Standard API to create the general journal entry. You can use the HTTP connector in Azure Logic Apps or the HTTP-triggered Azure Functions to send requests to the API.
Map the CSV data to the general journal fields and lines, following the API specifications. You may need to create the necessary accounts, dimensions, and other entities in Business Central beforehand.
Here are some resources that could be useful to implement these steps:
Microsoft Docs provides guidance and examples on how to use the Azure Blob Storage, Logic Apps, Functions, and other Azure services:
docs.microsoft.com/.../storage-quickstart-blobs-portal
docs.microsoft.com/.../connectors-create-api-azure-function
docs.microsoft.com/.../functions-create-your-first-function-visual-studio
Microsoft provides an API reference for Business Central, including the endpoints and entities used to manage general journals:
docs.microsoft.com/.../entity-generaljournalentry
There are various examples and tutorials available online that show how to use the Business Central API from different platforms and languages, such as:
community.dynamics.com/.../working-with-the-business-central-api-from-microsoft-power-automate
By combining these resources and adapting them to your specific needs, you should be able to read a CSV file from Azure Blob and create a general journal in Business Central using the BC Standard API.
DAniele
Hi Mr Bruvik
That is really kind of you. It is always harder to deal with BC development than Azure. But your kindness for sharing the code can help a lot.
Thanks
Yes, it is definitely possible. But I do not use API for it. I have a codeubit that is running in a jobqueue checking for new files on a Azure blob storage folder. I find it easier to customize it that way then using Azure Logic App.
I am not on the right computer now, but I will share my code on Github later today if no one else comes to your requeue before me.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (