We would like to be able to update price book prices automatically with an API call to our vendor webservice.  I'm not sure the correct way to do this.  Can I build a custom function that uses an API call to get the price of a certain part by referencing its part number and update the Base Cost and the MSRP automatically?

What I'm imagining is a function that I can run maybe once a week that will run through the items in the parts module and update each one with an api call.

Would this be possible?