I am working on a SaaS platform and I hope to be able to give customers unique URLs. However, the entire platform is one big system/database, and the URLs would be local-specific. For example, a submitted product for sale in Brooklyn, NY might look like: "AppName.com/ny/brooklyn/products/product-name" But since the Borough of Brooklyn is my customer, they may want to have their own URL, such as BrooklynProducts.com. In that case, I would want the URL to be "BrooklynProducts.com/products/product-name". How would I support many locations and states, have all the events listed in a single database, and still offer my customers a unique URL? Can you do a rewrite that makes "AppName.com/ny/brooklyn" be renamed to BrooklynProducts.com, and then add (/products/product-name) after it?
This isn't something I've done personally, and I'm not the right guy to walk you through it. But it should be possible. Online I see some public discussion about how to do such things with Microsoft Rewrite and IIS. Apart from URL rewriting, by using host headers, you can even allow white-label customers their own themes.
It's possible, but not the way you think.
The first is the top level domain. There are a couple of options. One is you'll need to DNS redirect from their web hosts to your address. Note this is not an HTTP redirect! If your servers take over the DBS hosting process, then you take control of that, which is something some CDNs do (such as CloudFlare). However, given you're asking the question, I'd suggest it might be too advanced for you if you've not got a good grounding in web networks.
The URL rewriting element will give you the rest of the path though. Indeed, if you're using MVC you get this out of the box through its routes (you just direct their path to your path). But the URL rewriting module is available for IIS in any case.
If you need any more help or info, happy to schedule a call in. Just ping me a message.