We have an Add in for apparel industry and using BC 24. They have an API that can import sales Header and Sales line data and it is working when sending in Json using postman. any one has ever worked to use these API calls via power automate to import the text file and convert that to json in one of the action in power automate an dthan send this data to BC in the next action?
1 Like
Hi Ali,
Yes, that’s definitely possible in Power Automate. You can pull the text file with “Get file content,” parse it into JSON in the right shape, and then use an HTTP action to push it into BC. We had a client run into something similar (not exactly the same case, but close), and this approach worked well for them; might be worth a try for you, too.
And if it doesn’t quite fit, feel free to reach out. Serving in this community is all about helping each other, and I’m happy to share what’s worked for us. You can always drop me a note at hardik.gupta@allgrowtech.com