The Socrata Open Data Transport allows you to perform Upsert operation on the data of a remote Socrata resource.
On the Basic tab, the user can specify the:
Service URL – the URL of the Socrata Open Data service. Sandbox service URL by default
Email – the username used for authentication,
Application Token – application (API) token of the user
Resource ID – ID of the resource to query
Input Data Type – User can specify what type of the data is expected to be sent to the server: CSV or JSON.
The Throw Exception checkbox allows the user to throw an exception when an operation fails.