I tried with the following url (with one of my dummy project) and it worked for me:
https://kc.kobotoolbox.org/api/v1/data/545827.xlsx
Maybe if you wish, you could make some dummy entries as well:
https://ee.kobotoolbox.org/x/w2cfGvN8
I could update the records (for both the household level as well as the roster information) once i press the refresh button.
Maybe this video tutorial prepared by @janna would help you solve your issue. Though the video pulls the data from an Excel file, you could still connect your data with the KoBoToolbox server:
