Requests from a tab
Method, URL, headers, query and body, saved in the workspace and addressed by URL like any other tab.
REST Client
Test APIs Without Leaving Your IDE.
Send HTTP requests, inspect JSON responses and work with API data alongside your database queries.
The REST client is in development. This page says what it will do, and how JSON already gets into Falcon Data Studio today.
What the REST client will do
A request tab next to your SQL tabs, with the response treated as data rather than text.
JSON inspection
The response in the JSON tab: collapsible tree, search and a grid view of arrays of objects.
Save responses to a table
Map a JSON array to columns with the same transforms as Import Data, then Merge or Append.
API steps in pipelines
A request as a source or a destination in a saved pipeline, with parameters.
What you can do with API data today
JSON is already a first-class file in Falcon Data Studio. Save a response from your API tool of choice and bring it in:
- Open File loads a .json file into a JSON tab (files up to 10 KB are kept in the local workspace, larger ones stay in memory for the session)
- Save to Database maps the objects to a table with the import mapping and transform engine
- Export writes any query result back out as JSON for the next request
Status
Honest accounting: the REST client has no shipped parts yet. The JSON path does.
- JSON files in and out
Preview Open File, the JSON tab and Save to Database.
- Export as JSON
Available Any grid as a JSON array.
- Request tab
Coming soon Send requests and inspect responses inside Falcon Data Studio.
- API pipeline steps
Coming soon Requests as sources and destinations.
From Raw Data to Working Solutions.
One workspace to connect, query, explore, transform, automate and build.
Whether you are managing databases, engineering pipelines or creating applications, Falcon Data Studio helps you get more from your data.
Start with the modern Data IDE: the Windows desktop app, or open it in your browser.