I saw several requests for OData compatibility, so I created this:
Installation
You can install it by typing n8n-nodes-odata in Settings/Community Node Installation on your self-hosted n8n instance.
What is OData?
Created by Microsoft in 2007, OData (Open Data Protocol) is an open protocol that allows the creation and consumption of queryable and interoperable RESTful APIs in a simple and standard way.
Node Features
GET, POST, PATCH, DELETE
Other features: $filter, $select, $orderby, $top, $skip
In addition to the basic features, there is also an input field for inputting a raw JSON query, which will override other options and allows for advanced usage.
I’m trying to connect to our local instance of SAP API. I can connect successfully with Postman/APIDog with the same info successfully but not with your OData node. In Postman I have to specify Body parameter which is Raw/XML and it creates 2 cookies B1Session & RouteID. I tried using the Advanced option with the XML in the Raw Query field but get an error. Should I be doing this another way?
Thanks for the feedback, Tim! When developing this version, I was using a server that didn’t require keeping session that way, so I will have to make some additions to the node after finding a new test server
That would be awesome! I’ve been looking for a solution to automating the creation of PO’s, SO’s etc in SAP Business One with their API for a while now and I think this node is the answer to my prayers!
I’ve just released version 0.2.0 to npm with OAuth support in the node. I’ve tested it with Microsoft Azure so far. If you reinstall the community node, you can let me know if it works for you now.
