Greetings to all of you.
Long story short, every night , a customer of mine , posts on my onecloud , an excel file which is basically a configuration package, including the sales header and the sales line table. ( data are coming from another ERP that the customer uses).
My task , is to create , an automatic process which will allow me to get the lines within the file and post them within the Business Central ( cloud version).
I tried using Power automate , so that i can open the file and post , through POST Request, all the needed information but i am having a hard time with the ID's since , for example, to post a sales line you need the itemid and not the item no..
Due to that, i would like to ask you , which is the most simple way to achieve this goal ? Can anyone share his/her experience please?!
Thank you in advance for your time.
With respect,
AK
