API to return Site Number
Within Fusion -> Receivables -> Manage Customers, using a SOAP or REST API how would I retrieve the Site Number as shown highlighted in red below:
Looking at other articles I can access the Account details, however for each account there are sites associated to them, it's the site number I need to gather using an API.
I can access the data I need using the HZ_PARTY_SITES table, under column party_site_number. Is there an API that can gather this data instead?
I have tried using the customerAccountSitesLOV REST API and the CustomerAccountService SOAP API, neither returned the Site Number shown in the above screenshot.