How to update bulk Supplier state address through Rest API or by any other possible ways

Summary:

Business to update 2k+ Supplier state address. Is there any way to achieve the requirement like (Rest API, FBDI,…)

Example: 7919 xxxx,77064,xxxx,TEXAS,xxxx -> 7919 xxxx,77064,xxxx,TX,xxxx

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):