Getting Product Info via SQL

[Stephen_Jackson_Twoday]

Hello. I’m trying to pull out all product info including any pics, for use in an external system. I only have sql access; no API. Can someone share some example queries? I’ve come a bit of the way but I’m not sure what many of the columns in the Prod table actually do so if they’re relevant.I tried to access documentation on community but its behind some kind of ISV Partner wall and we’re not an ISV partner.

[omelhus]

This is the forum for Business NXT and not on-premise.

If you need a graphql api for on-premise, have a look at https://apps.visma.com/NO/app/isv_onit_graphql_service. Images, documents and memo file content are all available through that api.

[Stephen_Jackson_Twoday]

Ok thanks. I have to check what is installed there. But if I had to go for pure SQL, i.e if I did not control what was installed on the business installation, what would be a good place to find documentation on the tables?