I have seen the request for the ability to import journals at Import journal but as that was 2018 and has only 8 votes I suspect that it is not likely to be something implemented. Though I did vote for it!
I have looked at Zapier but that does not have a Zap to enable importing of journals.
If I had my database admin system “create” the journals (which it could do as it has all the information) could I use the api to create the journals?
Reading the intro to the API I think the answer is yes but perhaps someone can confirm?
This would be the fall back and would work I am sure but I am hoping that I can use the API to “connect” to my admin system directly. e.g. I create a rental in the admin system and this triggers the creation of the invoice in QuickFile. All the information must be in the admin system and I’m hoping to avoid duplicated effort, which is currently required to maintain a proper set of accounts.
I just meant you can feel free to adapt my code, if you want an example of how I compute the authentication signature for the header section, etc. You can access the code (which is basically JavaScript with some google sheets specific libraries available in the global scope) by making a copy of my sheet and then going to extensions → apps script in the menu bar.
Thx Ian. I will have a look in due course and may have to get my tech wizzard to do something for me but it is reassuring that you can import journals through the api, though I do think it a shame that you can’t through a simple routine within Quickfile.