Configure.IT Blog

Learn about latest news in the Mobile App Development Industry, and updates about Configure.IT Platform

Configure.IT Blog

Feature Update: Automatic CRUD APIs, API Node handling, Data Preview

February 20, 2014

As a part of our commitment to make Configure.IT work in favor of you, we are trying everyday, to make it easier for you to use without any limitation.

At the same time – we’re equally focusing on fixing all those bugs and issues you’ve been submitting to the support portal. I am sure you’re experiencing improvements with the fixes – it is our promise to continue providing you great support and a refined experience.

Today, we are glad to share with you some exciting new features we’ve added to the platform. We’ve added some of the Key time saving features into our API and Database configuration suits.

These features will be available as you read this.

Automatic CRUD APIs for DB Tables

New functionality to create the APIs for CRUD operations on a specific database table is now available. You can simply create 5 different web services for each table, and later you can edit these API’s logic by the interface you already are using it today.

Features of CRUD Web Services

  • Create CRUD APIs with 1 click
  • Automatically inherit relational settings for multiple tables within CRUD APIs (e.g. Unique field, image settings, date format, where conditions, inherit calls to custom function applied to admin module settings, within these APIs)

Usage

  • Select
    • This API gives you only output parameters based on settings you select within the configuration interface
    • If there’s a status field included – then status condition is automatically added
    • Select API will return multiple records
  • Select by Field
    • This API requires input parameters – in the form of specific fields you want to select. The resultant output gives you the data for the selected input fields.
    • Select API by Field returns a specific single record.
  • Insert
    • Insert API requires you to mention input parameters in form of fields you want to insert records for.
  • Update
    • Update API is similar to Insert API, it requires input parameters in form of fields you want to update records for.
  • Delete
    • Delete API by default works with Primary Key value as input parameter, but you can also set up where conditions in interface if you require to have multiple deletionsof records.

New Facilities in API

Web services Configuration

Were you wondering if you could add a new node (block) in between any nodes within the flow chart? We’ve heard you. From today, you’ll be able to add ANY flowchart node at any place within the current web service flow.

You can also move around any node easily than before – anywhere within the current flow.

New Node Insertion Features

  • Right click on any node to see a menu – that allows you to insert new node or move current node at a specific place.
  • Insert After
    • Insert new block AFTER selected node and move immediate descendent node by one place.
  • Insert Before
    • Insert new block BEFORE selected node and move immediate descendent node by one place.
  • Shift Before
    • Shift current node before the target node
  • Shift After
    • Shift current node after the target node
  • Insert Left
    • For Conditional nodes – current node will be added on the LEFT of the conditional node
  • Insert Right
    • For Conditional node – current node will be added on the RIGHT of the conditional node

Web Service Validation Indicator

Added a new indicator that shows in run time, weather the web service is syntactically correct – and weather is ready to be executed or not.

  • green-bulb  –  API is syntactically CORRECT, and is ready to be executed.
  • red-bulb  –  API is syntactically INCORRECT, and is NOT ready to be executed.

Hovering over this indicator will show you the list of errors, and helps you solve them in order to make the API logic correct.

This is going to help any developer build the APIs quickly and bug free.

SQL Query Editor and Data Preview

Database Configuration

This has been a long awaited feature from many developers – to be able to quickly view the data records in a specific table. We’ve gone a mile ahead – and added a great degree of flexibility to view them. The option for “VIEW TABLE DATA” allows you to view all records contained in a data table.

 

database-preview

Beyond this – if you want to specific records – you now have freedom to view them by writing your own query and see records. The query option we’ve provided allows you to write your own query or build a simple query with ready to use options we’ve provided.

sql-builder

This should allow you to save time in previewing records with a few clicks just as if you’d do in PhpMyAdmin.

We hope these features would add to your productivity and efficiency. For any assistance with these new features – feel free to contact us via Live Chat or by Support Portal. We hope these new features will add to your productivity.

Thank you!

Team Configure.IT

 

Tags:

API,
CRUD,
SQL,

No comments

You must be logged in to post a comment.