My Products
Help
Stephen_Jackson_Twoday
CONTRIBUTOR *

Getting Product Info via SQL

by 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.

2 REPLIES 2
omelhus
PARTNER

by 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
CONTRIBUTOR *

by 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?