well – I somehow understood that you need only the CURRENT state . anyhow, what I proposed can be done also with soap, but IMHO – it is easier with with direct Sql query, and then parse that query and put it inside the correspondent wp table . you can use cron to give it timing intervals.
