Hello, I am trying to get a file from Salesforce using the Salesforce API Integration so I can attach it to an email I am sending through retool. When I use the CRUD Action, only the path is returned in the VersionData field.
I am trying to access this path: /services/data/v42.0/sobjects/ContentVersion/068Hp00000gsuloIAA/VersionData through another CRUD Action, but can't specify VersionData in the resource block like so:
Any help would be appreciated!
Hi @trevwilliams107 Thanks for reaching out!
I don't see a way to get this appended as a separate field in the query 
I'll move this to feature requests. What happens if you append /VersionData to the id?
If that doesn't work, could you do this in our generic Rest api integration?
The only way I was able to do this was to implement a REST Api query resource, and wire it up to Salesforce. With that, you get their full API. Using the builtin Retool integration with Salesforce, you’re limited in what you can do.
That said, what the OP is attempting to do here (ie get a blob from salesforce api) doesn’t seems possible since I can’t find a way to get the binary data without Retool mangling it.
