XMLport export with job queue on BC SaaS (Cloud)

(0) Share

Report

Posted on by Juliem

375

Hi,

We have an XMLPort that creates a CSV file for a BC16 SaaS instance. So far, that XMLPort was run manually by a user who would then save the file at the proper location, but we would like to automate it through a job queue.

Is there a way to do this? If I'm not mistaken, we can't use a mapped network drive as the Cloud is not aware of them. Shared URL on OneDrive could be a solution if there is no other way, but how do you pass on credentials to authenticate from the job queue?

Any input and idea would be greatly appreciated

Thanks

-Julie

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

JAngle 133 on at

Like (0)

Report

XMLport would need to be executed by a report or codeunit and you would more than likely need to store the credentials in the object or in a database location.

A different suggestion would be to create a query based on the XMLport. Publish that as a web service. Use power automate to call the web service with the HTTP connector. Store the JSON results in an Excel file (so will be saved in onedrive) and convert the file into CSV if needed after that. As standard it will look to place data into an Excel data table. With power automate you can use a recurring schedule for the export to take place.

Was this reply helpful? Yes No