LLodi Writer Connector

LLodi Writer Connector (formerly QvLLodi Connector) allows you to develop automatic actions from script every time the application is reloaded and taking profit of the scripting capabilities provided

Installation

See Getting Started: Installation

Available for QlikView and Qlik Sense

You can use LLodi widgets in all your Qlik projects, choose your favourite platform and use our tools seamlessly.

Natively embedded in Qlik

LLodi widgets works directly from Qlik, as custom extension or connector.

Security

LLodi is cloud-based and inherits the security of your Qlik Analytics Platform. No need to redo or replicate your security model. We do not store customer data.

Create connection

Create new data connection in Qlik Sense

Once you have unzipped the files in your directory you have to add the connector as a new Data Connection.

Select QvLLodi Connector from the list, a modal will be opened where you can login into LLodi.

Login Modal

Give to the connection your preferred name and complete your login credentials, check the connection and then you can finally create it.

Now the connector is available on your sidebar as a Custom Connector, insert your connection string and select your data to create and copy the generated script.

Create new data connection in QlikView

To be able to use LLodi Writer Connector in QlikView you must turn on WebView from View Menu. Then enter on Edit Script and choose our connector in Database.

Use your username and password to connect with LLodi. Test connection and then you can give LLodi access to QlikView.

Now your new data connection is ready to use within data load editor. Remember to copy your desired Qlik Script in the platform.

Using the LLodi Connector

Everytime you reload your app the connector will work, remember that you can apply the logic from Qlik to the connector and use variables to complete your Form Fields in the data load editor or the script.

Using the Wizard

To make easier using the LLodi Writer Connector, you can use the Wizard interface to create your script in a few steps.

Use your forms

You can use your forms created in the Forms Manager module to create your script. Search your form by name using the search box in the top left.

If you hover over the description you can see the full text

Once you have chosen your form, you only have to add values to the fields (remember that you can use Qlik formulas) and click on "Generate Script". You can directly copy and paste the script in your Qlik Script.

Forms: Advanced Options

In this section you can modify the request with advanced options.

  • Custom connection: You can create the request using "WITH CONNECTION()" options.

  • Parse JSON: The connector will try to transform the JSON response into a Qlik table.

  • Direct Payload: When enabled, the payload is sent "as it is" within WITH FIELDS().

  • Proxy: You can use the Agent capability "proxy".

    • LLodi Key: If enabled, enter the LLodi-key defined in the Core to be able to do the action.

    • LLodi Auth: Use some credentials stored in you agent.

    • Default Agent: If you don't want to use the default agent, define URL and port.

If you use Advanced Options, remember to generate the script before setting them up.

Send an email

LLodi Agent gives you the ability of sending emails directly from Qlik. You can add or remove fields.

You can change the Agent URL and port.

API Reference

Send a SMS

Use your Twilio or Nexmo account to send SMS directly from Qlik Sense thanks to your LLodi Agent.

If you want to use special fields you can write them in the Qlik Script

API Reference

Send a Tweet

Write your message and post it in Twitter from Qlik Sense.

API Reference

Trigger Sense App

Know more about the Trigger Function.

If you don't provide a tab name, it will be named "Tab created by LLodi"

Ping Qlik Sense

You can use the Qlik Repository Service or the Qlik Engine.

If you are using Qlik Sense Desktop you can only use Qlik Engine Ping

Generate from resident table

LLodi gives you the ability to use a Resident Table in your request.

Request Structure

QlikView
Qlik Sense
CUSTOM CONNECT TO "Provider=QvLLodiConnector.exe;"; //Select "Connect" to generate your Connection string
SELECT
FROM {name you want for the table} //optional; defaults to "LLodi"
WITH GUID {GUID} //optional; GUID for the Form you want to use, if any
//all optional from here
WITH FIELDS (
{FIELDS}
)
WITH CONNECTION (
/* If you didn't provide a GUID you must add the URL here:
URL "https://endpoint.url.com"*/
{CONNECTION PARAMETERS}
)
WITH CONFIG (
{CONFIG PARAMETERS}
);

WITH FIELDS ()

By default you can add the fields to your payload just by making pairs

SELECT * FROM Request
WITH FIELDS (
"key" "value",
"key2" "value2"
);

Depending on your content-type header, LLodi Connector will automatically convert your fields to x-www-form-urlencoded (default), application/json or xml. Like in the example:

application/json
x-www-form-urlencoded
xml
{
"key":"value",
"key2":"value2"
}

You can customize your payload even more by using DIRECTPAYLOAD in WITH CONFIG().

WITH CONNECTION ()

Keywords:

  • URL: override the URL defined in your form.

  • HTTPHEADER: add HTTP Headers. You must define key and value.

  • QUERY: add parameters to your URL. You must define key and value.

  • METHOD: override the method defined in your form.

These work the same way as in Qlik's REST Connector (although we have added METHOD).

SELECT * FROM Request
WITH CONNECTION (
URL "https://www.llodi.com",
HTTPHEADER "llodi-key" "value",
QUERY "id" "1234",
METHOD "GET");

This results in a GET request to https://www.llodi.com?id=1234 with a header llodi-key=value

WITH CONFIG ()

Keywords:

  • PARSEJSON: defaults to TRUE. The connector will try to transform the JSON response into a Qlik table. If FALSE or failed, a field Response LLodi is returned with the whole response.

  • KEEPTABLES: defaults to TRUE. When FALSE the connector will join the result tables.

  • DIRECTPAYLOAD: defaults to FALSE. When TRUE, the payload is sent "as it is" within WITH FIELDS().

SELECT * FROM Request
WITH FIELDS (
I'm sending whatever I want in my payload
)
WITH CONFIG (
PARSEJSON "FALSE",
DIRECTPAYLOAD "TRUE");

By doing this, we are building our request as it is and receiving the response straight as it comes in a field "Response LLodi".

Direct Payload if the payload is wrapped in an array

When you want to use Direct Payload feature, but your payload is wrapped in an array, you will need to add an additional square bracket plus space set. [ [{}] ] instead of [{}].

SELECT * FROM Request
WITH FIELDS ([ [{
"name":"John",
"age":30,
"cars":[
{ "name":"Ford", "models":[ "Fiesta", "Focus", "Mustang" ] },
{ "name":"BMW", "models":[ "320", "X3", "X5" ] },
{ "name":"Fiat", "models":[ "500", "Panda" ] }
}] ]);

WITH DB ()

This Syntaxis allow you to use LLodi DB module directly from the Script, you can also use the API url in a WITH CONNECTION expresion.

Keywords:

  • ACTION: "todb". This field is required

  • PORT: You must use the port of your LLodi DB module.

SELECT * FROM Request
WITH DB
(
action "todb", //this is the only one required
url "https://demo.url.com",
port "8093"
//connection, operation, schema, table, etc are used with the default value set
)
with fields
(
id "1",
email "hello@world",
unknown "lalala" //this field is ignored because it doesnt exist in the table
);

Using the LLodi Writer Connector in Qlik Sense Desktop

You can use LLodi Agent in Qlik Sense Desktop, but some features will work differently.

LLodi Writer Connector Vs Qlik REST Connector

We are working on this. Stay tuned!