LLodi Help

1.LLodi Help Center #

LLodi Help
Create a FREE Account now

LLodi Step by Step

 

LLodi Help is the best way to find updated documentation about the LLodi Platform.

If you need assistance and you currently have an account, you can contact our team by completing the support form in the bottom menu in the platform. If you don’t have an account yet, you can get more info by reaching us through the Contact Form at LLodi.com.

Yes No

1.1.What is LLodi? #

LLodi is a web-based platform that, from Qlik®, allows you to use your favourite apps or writeback in your DB. LLodi works with QlikView® and Qlik Sense

LLodi offers a full connectivity solution thanks to the combination of their different tools:

  • Writer Extension: Allow the user to enter data directly from the dasboard.
  • Writer Connector: Trigger actions from the Qlik Script ( Alerts, Notifications, Operational Tasks…).
  • LLodi Agent: Provides a server-side environment to make your requests safer and more powerful.
  • LLodi Service: Connect with your own DataBase from Qlik or store your data payload into a file (plain text, csv, json, xml…)

Yes No

1.2.LLodi Step by Step #

 

  • Create a FREE account
  • Log in to LLodi Platform
  • Navigate to LLodi Forms and create your first form.
  • Define your workflow with our Custom Integration Platform or use your favourite integration tool (Zapier, Scribe Online, Workato, IFTTT, Stamplay… )
  • Install the LLodi Widgets you may need:
    • LLodi Writer Extension
    • LLodi Writer Connector
    • LLodi Agent
    • LLodi Service
  • Start Take Actions on your Data Analysis.
  • Monitor the Apps taken with our Apps Monitor.
Yes No

1.3.What is in for me? #

LLodi platform gives you the ability to make actions directly from Qlik (available for Qlik Sense and QlikView), integrating data analysis into your business workflows. Connect your favourites applications to Qlik and put decision-making and action-taking literally in the same page.

LLodi helps organizations to implement Qlik in all the levels of users, becoming a data-driven organization. The focus on immediacy makes us unique, boosting productivity through improving workflows or automating tasks. LLodi can read directly from Qlik, so don’t have to switch tabs anymore and your Qlik insights will be available where you need it, no more “Copy & Paste”.

LLodi can be easily added to preexisting Qlik apps, providing additional functionality. No coding required!

LLodi can writeback to most Webapps and even to your DB.

Check our YouTube Channel or our Blog, to see working examples.

Here are other solutions that LLodi can add to your apps:

  • Use Slack as your Qlik Alert Center
  • Create alerts and notifications
  • Automate operational actions
  • Trigger actions based on events
  • Scheduled Metrics distribution through different channels.
  • Create orders or tasks in your CRM
  • Add or Update subscription lists.
  • Use the power of Qlik to segment your contacts and use this on your favourite apps.
  • And many more!!

If you have any question contact with us.

Yes No

2.Form Management #

Give your business the innovate app it deserves

 

In most cases companies work differently. For this reason, LLodi offers you the possibility of using preconfigured forms that automate some business processes or create your own forms and workflows that adapt to the needs of your business.

It doesn’t have to be hard, though. Use LLodi to build an app that’s a perfect fit for your business. You can even make analytics mobile apps to complete tasks on the go.

Yes No

2.1.LLodi Forms #

Our Llodi forms allow you to take actions directly from your BI application. Natively embedded in Qlik®, the form interacts seamlessly with the associative power of Qlik®. These forms have a flexible design that let you create a myriad of solutions.

The forms defined in the LLodi platform, can be used in two ways:

Qlik Sense® & QlikView® LLodi Writer Extension

Embedded in Dashboards, Mashups or Applications, our extension turns analytic dashboards into bidirectional interactive systems, letting you combine the logic defined in LLodi with Qlik® scripting. This provides an advanced environment for customization and complexity for consultants and, yet, a visual and user friendly appearance for the end user.

LLodi forms can also be triggered directly from Qlik® script with our Qlik Sense® & QlikView® LLodi Writer Connector

so you can develop automatic actions from script every time the application is reloaded and taking profit of the scripting capabilities provided by Qlik®.

Yes No

2.2.Building your own Forms #

If you already have a Workflow (Zapier, Workato, Scribe Online or Custom Integration), you can create your own forms to be used with LLodi.

This LLodi App lets you register new workflows just by adding a name and URL (WebHook, endpoint) and choosing a form type. You can also fill a description for the form or add tags to manage your forms easily.

Once you register a new form, you will be guided to the page to create/edit your LLodi Fields, in the option “Show form fields”.

At first the URL field can be empty, until the workflow has been created in the chosen tool. At that time, it will be mandatory to enter the WebHook address or the endpoint.

Yes No

2.2.1.Field Types #

Form Simple Forms

Input Text (the field number is defined as text)
Text Area
Select
Input Select Combo
Check box
Read Only
Hidden
Screenshot ( Save a screenshot as a base64 string)

For multi line forms:

Select
Text (the field number is defined as text)
Text Area
Checkbox

Form Table Forms:

Table

All Select type fields (Input Select, Input Select Combo, Multi Select) have the following feature:
Make name-id pairs with the separator “|”. In any select type field only the first subfield will be displayed, allowing to send additional info under the covers

eg: Name1|id1,Name2|id2
eg: Name|id|value

Combine this field type with the split formula to build a selector out of a csv list. Check out our Useful Formulas.

All Check type fields (Input Check, Multi Check) are default false.

Placeholders
You can edit the Placeholders for every text and area type field.

Labels
You can edit the Labels for every field that is not hidden.

Yes No

2.2.3.Need help setting up an advanced form #

Log in and complete this quick form if you don’t find a LLodi Form that meets your requirements or if you have some cool ideas you want to request and you do not have the time to customize your own form and worflow.

We offer managed services to build, run and support your Business Apps.

Yes No

3.Integration Platforms #

Workflow Integration

LLodi can connect to most webhooks and endpoints of the available cloud services, either using integration and automation tools (like zapier, workato or scribe) or directly to the target application. Thanks to that, the circle is close, performing operations that act directly on the main data origin.

Connect your Qlik App with more than 1.000 applications: Salesforce, Sugar CRM, Microsoft CRM, HubSpot, MailChaimp, and much more!

Yes No

3.1.Custom Connection #

LLodi Platform let you create a custom connection with any API, using basic or token authentication. To avoid CORS problems and use other authentication methods you will have to use our LLodi Agent.

To create a custom connection you will have to follow the next steps:

  1. Find the target endpoint in the documentation of your election app.
  2. If it’s needed get API token
  3. Choose you HTTP Method
  4. Add as many Custom HTTP Headers as you want. Don’t forget to click on the “+” button to add them!

 

 

Yes No

3.2.Zapier #

Zapier “Connect Your Apps and Automate Workflows” www.zapier.com

Zapier is one of the leading applications to automate easy-to-use cross-application workflows for both business and IT users. Ideal for developing simple processes (Zaps) with more than 1,000 applications.

Zapier offers a free trial for 14 days, which allows you to create any process without limits of steps or applications. https://zapier.com/signup

After creating the account, you have access to the platform in order to create your first Zap. In the Explore option, all possible applications that can be used are displayed. If you select Salesforce, you will see some pre-configured zaps and if we keep scrolling down, a box appears with the different actions that this connector allows.

A Zap can take several steps. If you create a Zap to be integrated into a LLodi form, in the first step you will always have to select the “Webhooks by Zapier” app.

In the “Choose Trigger” section mark the “Catch Hook” option – Continue
Set up Webhooks by Zapier Hook – Continue
The following screen appears, with the address “webhook url”. When you press OK, Zapier will wait for a test.

The address “Webhook URL” should be copied in the URL field of the Custom Forms that we are going to create. Add the name, the type, in this case Zapier and click on the insert button

If you know the fields to create the action, you can click on the icon and enter “Show form Fields” to add and configure the different fields that will later be used in the form and sent to Zapier.

If you know the fields to create the action, you can click on the gear and enter “Show form Fields” to add and configure the different fields that will later be used in the form and sent to Zapier.

If you do not know the fields, access the Zap in Zapier and select App in the second step, choose Salesforce and all available actions appear. Tag “Create Task”, click on the continue button (Zapier will ask you to connect your Salesforce account) and later a screen with all fields that you need in Salesforce will appear to create the task.

Cool, now you have all the information to create the form. It’s been quite easy, hasn’t it?

After creating the fields in LLodi, return to the Custom Forms screen and click again on the gear, on this occasion you will have to access the “Test Form” option of the gear to run the test. This process will connect LLodi and Zapier, and in the previous screen, you will be able to join each Salesforce field with a field of LLodi.

More help “Creating a Zap” in Zapier.

Yes No

3.3.Workato #

Workato is an enterprise-grade, cloud-based automation and integration platform. In Workato we will work with Callable recipes.

To create a Workato connection you will have to follow the next steps:

  1. Choose Workato as Form Type
  2. Get your Workato API Key. You can find it in your Workato Account/ Account Settings / API Key
  3. Create a new recipe and choose as trigger event “Callable recipes by Workato”.
  4. Give your Callable Recipe a name
  5. Define the Input Schema. You will create as many fields as your forms has.
  6. Define the Response Schema. This will be the JSON schema for recipe return values.
  7. Enable REST Endpoint, choose HTTP method and Service Path.   
  8. Choose your action, and follow the instructions for every app.
  9. When you have created your recipe click on Test in the top right of the page.   
  10. In Properties you can see the Recipe URL. Copy this URL in Form URL in the LLodi Platform.
  11. Your workflow is ready to work!
Yes No

3.4.Integromat #

Integromat is an automation tool. We create scenarios and we have to choose as trigger Webhooks. We don’t have yet the Integromat Form Type, but you can use Custom and choose POST as HTTP Method.

To create a Integromat connection you will have to follow the next steps:

  1. Choose custom as Form Type and POST as HTTP Method
  2. Enter in your Integromat account.
  3. In the top right of the page click on “Create a new scenario”.     
  4. Choose Webhooks and click on Continue.   
  5. Click on the Webhook module and choose Custom webhook as trigger.         
  6. Add a new name for your webhook or choose an existing one. Your URL will appear underneath the webhook name, copy this URL in Form URL in the LLodi Platform.
  7. Define your workflow using the Integromat interface.                                  
  8. Your workflow is ready to work!
Yes No

3.5.IFTTT #

If This Then That, also known as IFTTT is a free web-based service to create chains of simple conditional statements, called applets. We can use as event Webhooks.

To make a connection wit IFTTT you have to follow the next steps:

  1. Create a new form and choose as Form Type IFTTT.
  2. Enter in https://ifttt.com/my_applets and click on New Applet          
  3. Click on “+this” and choose Webhooks/Receive a web request as trigger.
  4. Choose an event name.
  5. Add an action and complete action fields.
  6. Your URL will be https://maker.ifttt.com/trigger/{the name of your event}/with/key/{Your key}
  7. Copy this URL in Form URL in the LLodi Platform.
  8. Your workflow is ready to work!
Yes No

3.6.Scribe Online #

Designing a LLodi Map

The Scribe Online Request-Reply Map
Create a Request-Reply map. The only thing you need to know is what fields you want and how you want them to behave.
As of the response, LLodi Widgets expect one single field named “Respuesta”. This field supports basic HTML to display whatever response you want to the end user.

LLodi Widgets already send some fields that you may want to use in your map:
– OSUser: BI End User that triggered the action.
– pn_guid: GUID of the LLodi Map.
– App_name: Field built in the Widget for monitoring purposes.
– App_id: Field built in the Widget for monitoring purposes.
– Selections: Field built in the Widget for monitoring purposes. You can use this to register the selections in specific fields in the BI dataset.

The LLodi Map
Check the different Field types available.

Assigning the target
– LLodi fields: (up to 9) make this the target whenever you want the widget to fill up this field in the form with data from the BI app.
– Console: make this the target of a field if you want to set the value directly from LLodi Platform.
– No target: make this the target of Text and Area fields.

Choosing a formula (for Select field types)
– senseField: in Qlik Sense, this formula will retrieve the content of a field and fill up the selector with the data from that field, you will also make selections directly into your app. In any other BI tool, this field will behave as if it had the split formula.
– split: use this formula to fill up the selector from a csv list.
– No formula: use this formula if you want the widget to leave the field as it is.

Yes No

4.Analytic Widgets #

Download: Put decision-making and action-taking LITERALLY in the same page with the LLodi Widgets, natively designed for:

Qlik Sense
QlikView

Yes No

4.1.Qlik Writer Extension #

Allows the user to enter data directly from the dashboard.

Yes No

4.1.1.Installing LLodi Writer Extension #

Qlik Sense Server

Download the .zip file from LLodi platform

Open the QMC on your Qlik Sense Server

Import the .zip file in your extension tab.

You can now find LLodi Extension in your Menu Extension in Qlik Sense

 

Qlik Sense Desktop

 

Download the .zip file from LLodi platform

Extract the .zip file to your default extension folder in Qlik Sense. Usually documents/qlik/sense/extensions

You can now find LLodi Extension in your Menu Extension in Qlik Sense

 

 

 

QlikView Server

Download the .zip file from LLodi platform

You must copy & paste the content of the extension to the server manually, depending on the operating system:

Windows Server 2008:

  • C:\ProgramData\QlikTech\QlikViewServer\Extensions\Objects

Windows Server 2003:

  • C:\Documents and Settings\All Users\Application Data\QlikTech\QlikViewServer\Extensions\Objects

If you want, you can define an alternate installation path for your server extensions within the QMC (QlikView Management Console)

You can now find LLodi Extension in New sheet object/Extension objects if WebView is on.

 

QlikView Personal Edition

Download the .zip file from LLodi platform

You must copy & paste the content of the extension to the folder manually, depending on the operating system:

Windows 7:

  • C:\Users\[user]\AppData\Local\QlikTech\QlikView\Extensions\Objects

Windows XP:

  • C:\Documents and Settings\[user]\Local Settings\Application Data\QlikTech\QlikView\Extensions\Objects

You can now find LLodi Extension in New sheet object/Extension objects if WebView is on.

 

 

Yes No

4.1.2.Qlik Sense Extension #

Qlik Sense Extension

Download the extension
Install the extension in your server or your desktop version.
Drag and drop the extension into the dashboard.
Introduce the GUID of the LLodi Form you are going to use.
Fill up the LLodi Fields.
Fill up the monitoring fields.
Custom the style of the LLodi Form.
Check out some Useful Formulas

You have the possibility to use the same extension for different forms. Ask our support team.
SenseField Feature: With Qlik Sense you can just select one existing field to fill up a selector.

Keep in mind:

The default value for the fields Enter App Name,Enter Title and Enter Context are DocumentName(), DocumentTitle() and GetCurrentSelections(). Make sure you check it before you start working with your LLodi Workflow. You may need to select it and press Enter to force Qlik Sense to evaluate those formulas.

In some cases a Workflow may get you back a selection. In those cases a button “Select” will be displayed besides your Response.

Yes No

4.1.3.QlikView Extension #

Qlik View Extension

Download the extension
Install the extension in your server or your personal edition.
Go to web edition mode.
Right-click to add the extension into the dashboard.
Introduce the GUID of the LLodi Map you are going to use.
Fill up the LLodi Fields.
Fill up the monitoring fields.
Check out some Useful Formulas.

Yes No

4.1.4.Useful Formulas #

Make a Concatenated list

LLodi Widgets use comma separated lists to build the selectors and to send several values in one shot.

Qlik Sense and Qlik View:
concat(field,separator,sortby)
eg: concat(region,’,’,regionid)

 

Make lists of pairs

In most cases you will want to make pairs name-id so LLodi can display the name while uses the id to make the operations under the covers. In those cases you just need to go one step further:

Qlik Sense and Qlik View:
concat(fieldname&’|’&fieldid,separator,sortby)
eg: concat(region&’|’&regionid,’,’,regionid)

 

Make lists with additional info attached

Once you’ve got started you may think of new LLodi Form that you want to request. For example, you may want to send additional info beside the name and id, such as the total sales amount of one particular client.

Qlik Sense and Qlik View:
concat(distinct aggr(only(name)&’|’&id’|’&sum(value),aggregatedby),separator,sortby)
eg: concat(distinct aggr(only(region)&’|’&regionid’|’&sum(amount),regionid),’,’,region)

DateFormat

Certain LLodi Forms allow you to choose the date format for your users to input.
The DateFormat value is composed by dateparts sort and separator.

DateParts sort:
mdy: mm/dd/yyyy
dmy: dd/mm/yyyy
ymd: yyyy/mm/dd

Separator: choose the symbol your users will use.
eg: dmy/
31/12/2016
eg2: mdy-
12-31-2016

Yes No

4.1.2.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 by Qlik.

Installing your connector

To install Custom connectors, you have to copy the files from the zip into the directory:

C:\Program Files\Common Files\Qlik\Custom Data\QvLLodiConnector.

Using this path, the connector will be available both for QlikView and Qlik Sense.

Restart Qlik and begin to use QvLLodi Connector!

*Some versions of QlikView may not work in that path, in that case use:

C:\Program Files(x86)Common Files\QlikTech\Custom Data\QvLLodiConnector.

 

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.

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 your connector

Once you have connect with the LLodi Writer Connector you can use within your data load editor.

Just connect with the connector, complete the fields and copy the generated script.

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.

Advanced Options: Override Request

In addition to WITH FIELDS (), you can add the sentence “WITH CONNECTION ()”, that will override URL, Headers and/or query parameters using the keywords: “URL”, “HTTPHEADER” and “QUERY”. This works the same way as REST Connector.

Keywords:

  • URL: Using this keyword you can replace the URL define in form settings in LLodi Platform.
  • HTTPHEADER: We can use this keyword to add as many headers as we want to the payload. We must define key and value.
  • QUERY: With this keyword we can add parameters to the URL, we can also add as many parameters as we want. We must define key and value.
  • METHOD : Using this keyword you can choose the HTTP Method

You can also add the sentence “WITH CONFIG ()”, that allows you con control the response processing and define the format of the payload using the keywords: “PARSEJSON” and “DIRECTPAYLOAD”.

Keywords:

  • PARSEJSON: This option is enabled by default (“TRUE”) and parse the response json as key-value fields. When it is deactivated (“FALSE”) the whole response Json , without parsing, is provided in the field response. Accepts TRUE or FALSE as values.
  • DIRECTPAYLOAD: This option is disabled by default (“FALSE”), when it is disabled the payload is sent as key-value fields. When enable (“TRUE”) the payload is sent “as it is” in the script, keeping the indentations and spaces allowing you to add format to your payload.

Example:

Select * from Slack
with fields (“text” “value”, “channel” “value2”)

WITH CONNECTION (URL “https://www.llodi.com”, HTTPHEADER “Content-type” “application/json”, HTTPHEADER “Accept-Language” “*”, QUERY “id” “1234”, QUERY “OLDIE” “1952”)

WITH CONFIG (PARSEJSON “FALSE”, DIRECTPAYLOAD “FALSE”);

 

In this case the details of our request will be:

 

URL:

“https://www.llodi.com?id=1234&oldie=1952”

Headers:

Content-Type: application/json.

Accept-Language:*

The payload will be:

{
  "text": "value",
  "channel": "value2",
}
and we will receive the response without parsing.
Yes No

4.1.2.1.Installing your LLodi Writer Connector #

To install Custom connectors, you have to copy the files from the zip into the directory:

C:\Program Files\Common Files\Qlik\Custom Data\QvLLodiConnector.

Using this path, the connector will be available both for QlikView and Qlik Sense.

Restart Qlik and begin to use QvLLodi Connector!

*Some versions of QlikView may not work in that path, in that case use:

C:\Program Files(x86)Common Files\QlikTech\Custom Data\QvLLodiConnector.

Yes No

4.1.2.2.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.

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.

Yes No

4.1.2.3.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.

Yes No

4.1.2.4.Using LLodi Writer Connector #

Once you have connect with the LLodi Writer Connector you can use within your data load editor.

Just connect with the connector, complete the fields and copy the generated script.

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.

Yes No

4.1.2.5.Advanced Options #

Additional statements can be used in the script to modify our call.

Yes No

4.1.2.5.1.Advanced Options: Override Request #

In addition to WITH FIELDS (), you can add the sentence “WITH CONNECTION ()”, that will override URL, Headers and/or query parameters using the keywords: “URL”, “HTTPHEADER” and “QUERY”. This works the same way as REST Connector.

Keywords:

  • URL: Using this keyword you can replace the URL define in form settings in LLodi Platform.
  • HTTPHEADER: We can use this keyword to add as many headers as we want to the payload. We must define key and value.
  • REQUEST: With this keyword we can add parameters to the URL, we can also add as many parameters as we want. We must define key and value.
Yes No

4.1.2.5.2.Advanced Options: Override Configuration #

You can also add the sentence “WITH CONFIG ()”, that allows you con control the response processing and define the format of the payload using the keywords: “PARSEJSON” and “DIRECTPAYLOAD”.

Keywords:

  • PARSEJSON: This option is enabled by default and parse the response json as key-value fields. When it is deactivated (“FALSE”) the whole response Json , without parsing, is provided in the field response. Accepts TRUE or FALSE as values.
  • DIRECTPAYLOAD: This option is disabled by default, when it is disabled the payload is sent as key-value fields. When enable (“TRUE”) the payload is sent “as it is” in the script, keeping the indentations and spaces allowing you to add format to your payload.
Yes No

4.1.2.5.3.Advanced Options: Example #

Select * from Slack
with fields (“text” “value”, “channel” “value2”)

WITH CONNECTION (URL “https://www.llodi.com”, HTTPHEADER “Content-type” “application/json”, HTTPHEADER “Accept-Language” “*”, QUERY “id” “1234”, QUERY “OLDIE” “1952”)

WITH CONFIG (PARSEJSON “FALSE”, DIRECTPAYLOAD “FALSE”);

In this case the details of our request will be:

URL:

“https://www.llodi.com?id=1234&oldie=1952”

Headers:

Content-Type: application/json.

Accept-Language:*

The payload will be:

{
  "text": "value",
  "channel": "value2",
}
and we will receive the response without parsing.
Yes No

4.1.2.3.LLodi Agent #

LLodi Agent works in the Qlik Sense server between the LLodi call and an external request. It provides additional functionality to your LLodi Platorm:

  • Schedule reloads and create tasks in your QMC directly from your Qlik Sense dashboard.
  • Centralize your authentication credentials. LLodi Agent support Oauth authentication
  • Send email, SMS and Tweets directly from Qlik Sense
  • Avoid CORS problems acting as a proxy

 

 

Yes No

4.1.2.3.1.Paths #

  • Proxy: Work as a proxy, the petition goes to the Agent instead of the final endpoint, that made the request from the server. Some headers can be added or removed.

                We use this structure:

                https://myserver.com:8090/proxy?https://myendpoint.com

Reload

Ping

Create and update tasks

Start Tasks

  • Email: We can send an email directly from Qlik Sense. The email credentials must be added in the configuration page.
  • Twitter: We can send a Twitter directly from Qlik Sense. The Twitter credentials must be added in the configuration page.
  • SMS: We can send a SMS, using Twilio or Nexmo, directly from Qlik Sense. The Api Credentials must be added in the configuration page.

 

Yes No

4.1.2.3.2.Configuration #

In Configuration there are different options that can be defined:

  • Ports: By default LLodi Agent uses 8090 port to HTTPS and 8089 port to HTTP, but you can easily change it.
  • LLodi Key: This option can be enabled or disabled. When enabled is required that the request add the header ‘Llodi-key’ to work.
  • Certificates: PFX or PEM certificates are allowed.
  • White-List: In this section you can define the domain or IPs that that should be trusted.
Yes No

4.1.2.3.3.Connections #

Create the connections with your apps so you can manage them from the LLodi Agent. To use the saved connections from Qlik you only have to add the header ‘llodi-auth’ using as value the name of the connection, you can also choose the connection in the menu extension within Qlik Sense.

Yes No

4.1.2.3.4.LLodi Service #

Connect with your own DataBase from Qlik or store your data payload into a file (plain text, csv, json, xml…)

Yes No

5.Monitoring Dashboard #

Actions Monitor

Use our built-in app to monitor the decisions that have been taken with your LLodi Forms in ypur Qlik dashboard.
If you prefer, you can retrieve the data with our REST API and build a fancy BI app with it.

Yes No

6.Account Settings #

Account Settings

Yes No

6.1.Security Console #

Usually there is only one admin user to manage the LLodi environment. In case it is necessary to have more users, you can request their creation to the support team. In cases that multiple users exist, it will be possible to confirm the access to the different options through the creation of labels and their subsequent allocation to the user.

Yes No

6.2.Rest Api Client #

This part of the help page describes the LLodi REST API specifications for developers and some general guidelines you may need in order to use the API. For all your requests you will need en API key that will be assigned to you once you have a LLodi account. Below it is described how to obtain the key via an API request.

 

GENERAL GUIDELINES

Base URL: https://platform.llodi.com
Response: All API responses are given in JSON format so make sure your client accepts JSON. Usually your request will need to add the header “Accept” with “application/json” value
All REST API responses contain the header “Content-Type” : “application/json” and are in UTF-8 format.
HTTP method GET is used to te retrieve info from the API. HTTP method POST is used to insert info via API
Response Codes:
Success: 200
Fail:
– 400 for bad request (requirements are not met)
– 404 for not found request (data is not found )

API KEY
In order to get your API key you must have an active LLodi account and make an HTTP request to the REST API with following requisites:
Endpoint: https://platform.llodi.com/api/rest/v1/security/apikey
Method: POST

Headers:
– Parameter name: Authorization
– Parameter value: base64(username:password) where base64(username:password) referes to your LLodi username (email) and password coded in base64 format. Base64Encoder E.G. base64(millodiusername@mycompany.com:myllodipassword)

If all requirements are correct you will get your API key with the following model:
{
“Api_key” : “YourApiKey”
}

ENDPOINTS
Below there is a list with all endpoints available and their specifications.

Get all decisions
Description: Get your decisions from LLodi Decision Monitor. These request can be filtered by several fields.
Method: GET
Path: /api/rest/v1/decisions/{apiKey}
Parameters:
– user (optional)
– type (optional)
– startDate (optional)
– endDate (optional)
– app(optional)
– foreign_parent(optional)
– foreign_child(optional)
– limit (optional)
– offset (optional)

Response model:
[
{
“pn_guid”: “”,
“pn_name”: “”,
“pn_template”:0,
“api_key”: “”,
“decisions_guid”: “”,
“created”: “”,
“decisions_type”: “”,
“decision”: “”,
“details”:””,
“description”: “”,
“app_name”: “”,
“user”: “”,
“details_id”:0,
“n_rows”: 0,
“foreign_parent”: “”,
“foreign_child”: “”
}
]

Get KPI
Description: Get your KPI from LLodi Decision Monitor. These request can be filtered by several fields.
Method: GET
Path: /api/rest/v1/decisions/{apiKey}/kpi
Parameters:
– user (optional)
– type (optional)
– startDate (optional)
– endDate (optional)
– app(optional)

Response model:
[
{
“types”: 0,
“decisions”: 0,
“details”: 0,
“users”: 0,
“rows”: 0
}
]

Get field
Description: Get fields values from LLodi Decision Monitor field.
Method: GET
Path: /api/rest/v1/decisions/{apiKey}/field/{field}
URL: {field} represents the field you want to get data from.

Response model:
[
“”,
“”,
“”
]

Create a decision
Description: Creates a decision in LLodi.
Method: POST
Path: /api/rest/v1/decisions/create/{apiKey}
Headers: Authorization : base64(username)

Request body model:
{
guid: “” , (required,unique),
name_users_id:0,
apps_details_id:0,
decisions_type:””,
description: “” ,
sense_app_name:””,
sense_app_id:””,
sense_user_directory:””,
sense_user_id:””,
sense_selections:””,
foreign_identifier: “”,
closed :0,
value :0,
comments: “”,
n_rows:0,
pn_pn_guid:””
}

Response model:
{
response: “Record created”
}

Create decision details
Description: Creates decision details in LLodi.
Method: POST
Path: /api/rest/v1/decisions/create/{apiKey}/details
Headers: Authorization : base64(username)

Request body model:
{
decisions_guid: “” , (required)
description: “” ,
details: “”,
foreign_identifier: “”,
closed :0,
value :0,
comments: “”
}

Response model:
{
response: “Record created”
}

Yes No

6.3.Time Balance #

Check how many support hours you still have available for your customizations and in what actions they have been used so far.

Yes No