I was able to link my SQL database to a wix collection. My issue now is that even though I have a permissions secret giving read permissions to “Everyone” the wix collection still shows it for “admin” only…unlike internal collections, I just can’t change permissions through the content collection…can someone please point me in to the right direction? Tks!!!
same here
Same for me. The documentation talks about adding a stringified object called PERMISSIONS inside the secret key section but that does not seem to be working.
You should add an environment variable called PERMISSIONS, it should be strigified object as documented here
example for a valid value:
"{\"collectionPermissions\":[{\"id\":\"yourCollectionName\",\"read\":[\"Admin\",\"Member\",\"Visitor\"],\"write\":[\"Admin\",\"Member\",\"Visitor\"]}]}"
Did this work for you ? I just keep getting a 500 error - although I can see it in Preview mode (which makes sense as the user is Admin in Preview).
Where do you get 500?
On the app-info page (‘/’ route on the adapter URL) the permissions is section green?
I get the 500 error when testing the live page.
However I just checked the Azure Permissions Config and can see that the PERMISSIONS secret is not being applied - which probably explains this.
So I guess I am back to my question about how you set the PERMISSIONS secret correctly in Azure - I used the following, which is just an edited version of your example:
"{\"collectionPermissions\":[{\"id\":\"WixPortalProperties\",\"read\":[\"Admin\",\"Member\",\"Visitor\"],\"write\":[\"Admin\"]}]}"
I also tried with a collection ID copied from the Wix External Database - see screenshot:
That ID value is “RealpointCRM/WixPortalProperties” rather than “WixPortalProperties” - but that doesn’t work either.
You should use only the collection name, without the namespace prefix, try to allow Admin,Member,Visitor to see if it works.
In the picture I see only admin and member
Thanks for helping with this.
I am using only the Collection Name - the settings in the PERMISSIONS Secret are as I posted:
"{\"collectionPermissions\":[{\"id\":\"WixPortalProperties\",\"read\":[\"Admin\",\"Member\",\"Visitor\"],\"write\":[\"Admin\"]}]}"
However when I check the azurewebsites.net URL (to test the config) it indicates that it has not picked up the “Visitor” value.
Note the text “Config part that read successfully” so for some reason it is ignoring “Visitor”.
I wondered if there were other values we should be using - see this article:
This does not mention “Visitor” - so where are the definitive values for read/write permissions defined
Probably didn’t update yet, you should see the visitor as well
Yes, I noted that even after deleting the PERMISSIONS Secret, then re-adding, and stopping / starting the Web App, changes are not always visible.
Do you know any techniques to force it to refresh ?
I found some notes here:
https://stackoverflow.com/questions/55487930/key-vault-value-does-not-update-if-value-changes-in-secret-as-it-generates-new-v