One inventory file, two endpoints
How to publish a retail price endpoint and a wholesale price endpoint from the same sheet.
Publish two views of one inventory file.
Start with one inventory sheet. The columns in this example are sku, name, retail_price, and wholesale_price. Import the file once. Storage counts that file once.
Choose the fields
The retail endpoint keeps sku, name, and retail_price, and renames them only if you want different JSON keys. Hide wholesale_price. A hidden field is left out of the JSON and cannot be changed through that endpoint.
Who can read each one
Publish a second endpoint on the same file for the wholesale view. Give it sku, name, and wholesale_price. Each endpoint has its own access key. Someone who has the retail key does not receive the wholesale column, and the other key does not receive the retail column.
What this does not do
The keys are secrets for that endpoint. FileToAPI does not add a second copy of the spreadsheet. Filters on either endpoint are still the same endpoint. Read Pricing for how many published endpoints a plan includes, and Quickstart for the path from preview to the first GET.