1

I am in the process of using VBA in SolidWorks' to integrate Autodesk's PLM 360 into SolidWorks. The problem is that I have very little experience interacting with REST APIs, and it seems like uploading files to a cloud application is probably the most complicated part of that. In any case, it is very important for me to be able to do two things with VBA from SolidWorks: (1) add images to an item's description (documentation), and (2) upload and attach files to an associated item (documentation).

In any case, the PLM 360 documentation explains things fairly clearly, and this blog post (specifically, the approach using WinHttp.WinHttpRequest.5.1) seems to do a decent job of explaining the VBA side, but I'm struggling to figure out which things are important from each of the given examples.

Here are the main things that are puzzling me at the moment:

  1. The PLM 360 documentation seems to indicate that one request is being sent in two parts, but I don't understand how to do that in VBA.
  2. The code in the blog post surrounds the binary file with STR_BOUNDARY. Is that necessary in all cases, or is that something that's necessary only for some APIs?
  3. The code in the blog post includes the Content-Disposition and a few other things in the binary portion. Again, is this necessary in all cases, or is that something that's necessary only for some APIs?
  4. The caveat to the pvToByteArray function is confusing to me. I understand that it is converting back to a byte array the string containing the file data, but if #3 above is not necessary in PLM 360, is it necessary to convert the file to a string and then back to a binary "blob", or does that result in it being possible to pass baBuffer without failure?
  5. How do I include the rest of the information in the request for creating the item? I suppose this is somewhat related to #1 above, but I don't understand how to send API calls in two parts.

Ultimately, I'm posting this question here because I don't think people on the SolidWorks forum would have enough experience with REST APIs to be able to help, and experience shows that the people in the PLM 360 forum don't have enough experience with VBA to be able to help. StackOverflow seems like the place with the best chance of having people with experience in both areas.

tlewis3348
  • 424
  • 2
  • 7
  • 21
  • 1
    Much of your question (multipart submissions, "StrBoundary" and binary file posting) relates to basic HTTP issues, and is not specific to Solidworks or to specific API's. A little research on HTTP POST would probably clear up a lot of your concerns. Eg: right here on SO http://stackoverflow.com/questions/4526273/what-does-enctype-multipart-form-data-mean – Tim Williams Nov 20 '15 at 17:28
  • Thanks for the hint. I'm a mechanical engineer with a little programming experience (primarily with VBA and Matlab), so I feel like I'm in way over my head, but it needs to be done, so here I am. :) – tlewis3348 Nov 20 '15 at 17:35
  • Regarding `STR_BOUNDARY`, I'm confused as to why the blog post has it, but the help documentation for PLM 360 doesn't. I can understand why it's necessary to define the beginning and end of the binary data, but the PLM 360 documentation seems to indicate that it isn't for some reason. – tlewis3348 Nov 20 '15 at 17:50
  • You need it for a multipart request - I think they're just not calling it out explicitly – Tim Williams Nov 21 '15 at 16:50

0 Answers0