SQL Api - Execute SQL via external POST queries

by Konzeptphase, Florian Bettzieche

Rating: 5.0

(1 reviews)

Downloads: <10

An external SQL execution facility: simple POST requests to the API will execute SQL queries and deliver the result as JSON. Secured by IP or key. Every query will be logged.

Annually €12.42* /month €168.00 * €149.00* /year 11.31% discount In comparison to the regular monthly price

Monthly €14.00* /month Cancelable monthly

Compatible with:

6.4.0.0 - 6.6.8.2

Includes:

Free trial month

The subscription starts with a free trial month during which it can be canceled at any time.

All updates

During the subscription all released updates are included for free

Support from the Extension Partner

In case you have any questions or problems with your extension you can always ask the Extension Partner for help during the subscription.

Description

Highlights

Flexible SQL execution
Output in JSON format
Security in focus
Control and protection mechanisms

About the Extension

Our plugin offers an extremely flexible, external SQL execution option. With ease, you can initiate SQL queries through simple POST requests to the API, and the resulting output is provided to you in a user-friendly JSON format. In addition, we ensure the highest level of security by securing access to the API through IP filtering or the use of keys. This ensures that your data and queries are always protected and controlled.
Every "SQL query" is logged in the database and can be read out if required.
Some examples would be to retrieve the stock levels of all products or to control the product status of various products.
The following systems have already tested our SQL Api: SAP Business One, XENTRAL, Sage.

Explanation of the requests

Send POST request to the following endpoint::
https://***SHOPWAREURL***/api/kzphSqlApi/execute

POST Parameter:
hash = the secret key, if necessary (see plugin configuration).
cmds= the SQL queries which are to be processed in sequence. Separate these with ;.

Example cUrl:
curl
--location 'https://***SHOPWAREURL***/api/kzphSqlApi/execute'
--form 'hash="ThisIsASecret!"'
--form 'cmds="SELECT * FROM `order`LIMIT 5; SELECT * FROM kzph_sqlapi_log ORDER BY created_at DESC;"'

Detailed documentation and PHP examples are available here::
https://www.konzeptphase.com/fileadmin/SQLApi-Documentation-Example.zip

Do you have any questions or problems? We are available for you at any time.
Either via the Shopware ticket system or by e-mail to service@konzeptphase.com

Details

Available: English, German
Latest update: 11 November 2024
Publication date: 10 October 2023
Version: 1.0.1
Category: Administration

Resources

Reviews (1)

Average rating

5.0

Based on 1 reviews

5.0 Functionality

5.0 Usability

5.0 Documentation

5.0 Support

Write a review

If you downloaded this extension you can write a review in the Shopware Account.

Write a review

Sort by

Endlich kann unser ERP noch besser mit Shopware interagieren!

5.0

by Nam

10 October 2023 07:53

Vielen Dank für diese Erweiterung!
Das löst ein langes Problem auf unserer Seite.
Wir benötigten eine schnelle Möglichkeit um Lagerbestände und Bewegungen abzurufen,
da Shopware von Haus aus keine ERP Funktionen anbietet.

5.0 Functionality

5.0 Usability

5.0 Documentation

5.0 Support

About the Extension Partner

Konzeptphase, Florian Bettzieche

See all extensions

Partner Status

Shopware
Extension Partner

Details

Ø-Rating: 4.9

Average rating of 4.9 out of 5 stars
Partner since: 2022
Extensions: 5

Support

Based in: Germany
Speaks: German, English
Response time: Very quickly