Hi,

I'm having trouble setting up Qlik Sense Desktop to pull data in from our ticket system Freshdesk due to issues with pagination.

API call in the following structure:

https://domain.freshdesk.com/api/v2/tickets?page=x

There's also a URL returned in the response header in the following structure:

Link: <https://domain.freshdesk.com/api/v2/tickets?page=x>; rel="next"

What are the correct settings for pagination in the data connection? Is URL possible, or does it have to be custom script?

An important point: there's nothing in the headers that refers to total responses from the query, so if the API call actually returns 50,000 tickets I wouldn't know and I'd just have to loop through until I hit a page that has a JSON string length of < x. This is exactly what I do in a custom c# app that parses the JSON and loads an SQL server but I'm looking at Qlik as a solution that negates the need for a data warehouse.

Thanks all

Follow this link: Using external credentials | Qlik Replicate Help I was able to have Qlik access my HashiCorp vault and pull in the password. I am looking to automate the rotation of these credentials. This creates a new username and password. Is there a way to dynamically pull in the username from vault as well as the password?

Hello,

I am facing some issues while decoding Avro encoded messages. 
Here is some information about my application/issue:

• I am using Kafka as a target endpoint
• Message format is Avro without compression
• The metadata messages are read from the metadata topic
• We are using the Avro schemas to generate Java classes using the avro-maven-plugin. This allows easy mappings to POJOs using MapStruct for further actions within our app.
• Then instantiating Schema, SpecificDatumReader for each type of message to decode at application startup. 
  When a message is received, its Schema is looked up and a SpecificDatumReader is instantiated. SpecificDatumReaders could be cached once I have debugged the current issue.
• the provided decoder with the SDK works fine with the length of byte [] array to be decoded is <= 8192
• I see that the DecoderFactory provides a method: configureDecoderBufferSize(int size)
  When I use this to expand the size of the buffer, the decoding works fine on the first kafka message that is received, however, the subsequent kafka message decoding fails for a given schema.
• The SDK that I have access to uses avro-tools v1.8.1

I would appreciate any comments/feedback on this issue. 

Our version: QLIK Sense Enterprise for Windows version  Aug 2023 Patch 14

We would need some sample code that allows us to easily backup apps
-i.e. save them as QVF without data- from a certain stream or based on certain tags

Thanks in advance!

Good day, Qlik Community!

Qlik Connect is just around the corner! To celebrate and welcome the entire Qlik Community to join us next week in Florida, I’ve crafted a refreshing new green drink.

Introducing QlikFusion.

Skål

Hello everyone, i'm pretty new to QLIK and I need some help because i'm desesperate. 
I created a table manually (i had a csv, and find a way to recreate it in SQL to manipulate) and use it to manipulate datas using other tables from an Oracle data base.I test my script using DBeaver. Here is a part of my code :