Welcome to the Onshape forum! Ask questions and join in the discussions about everything Onshape.
First time visiting? Here are some places to start:- Looking for a certain topic? Check out the categories filter or use Search (upper right).
 - Need support? Ask a question to our Community Support category.
 - Please submit support tickets for bugs but you can request improvements in the Product Feedback category.
 - Be respectful, on topic and if you see a problem, Flag it.
 
If you would like to contact our Community Manager personally, feel free to  send a private message or an email.
Linking a document to an external database
boon_ong575                
                
                    Member Posts: 11 ✭                
            I need to link one of my documents to an external database. The database has a list of materials and I need to assign a material to a part of the document (e.g. a surface). How can I:
a) link the document to an external database
b) select a surface or a part (item) and access the database to assign the property
c) display the result in a display box on the document toolbar
I can't seem to find any resources on this in the Learning Center.
Best Answer
- 
            
chadstoltzfus
                        
                        
                            Member, Developers, csevp Posts: 164 PRO                        
                    Couple of challenges to tackle but this is doable. Here's where I would at least start; if you want to have it so you can drive the assignment from Onshape, you'll want to look into Onshape's API. They have an intro to the API course and they just released a new quickstart course.
You'll want to probably look into extensions, this will give you a fly out tab that can get the part id of a part that is currently selected. From there I imagine you could grab the property list from your database and give the user a list of selections to assign to that part.
Applications Developer at Premier Custom Built
chadstoltzfus@premiercb.com0 
Answers
Couple of challenges to tackle but this is doable. Here's where I would at least start; if you want to have it so you can drive the assignment from Onshape, you'll want to look into Onshape's API. They have an intro to the API course and they just released a new quickstart course.
You'll want to probably look into extensions, this will give you a fly out tab that can get the part id of a part that is currently selected. From there I imagine you could grab the property list from your database and give the user a list of selections to assign to that part.
chadstoltzfus@premiercb.com
Many thanks, @chadstoltzfus. Will look into this.