Automate Price fx Price Lists

I need a repeatable way to build my product price lists directly inside Pricefx without touching spreadsheets. All source data already sits in our internal database; however, I am not certain whether it is SQL-based or something else, so the very first step will be to identify the best connector or API call and set up the pull.

The automated flow must:
• extract fresh data from the database,
• map Product IDs, Product Descriptions and every Price Tier we maintain,
• populate a Pricefx price list (or price grid) on a scheduled or on-demand basis, and
• log any rows that fail so we can correct them quickly.

Please build the script or integration inside Pricefx (Groovy, REST API, or another native option you recommend), test it with a sample data set, and give me short written instructions so my team can re-run or adjust the job later. Once I can press a button—or let a nightly schedule do it—and see an up-to-date, error-free price list in Pricefx, the project is done.