Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This seems to be a very common question with very little successful responses.
I am attempting to pull ticket data from our OneDesk Environment so that I can build a dashboard. I am able to successfully connect using a GET REST connection to pull the information for a specific ticket ID, but I am unable to pull a list of IDs using the POST / filter method proposed by OneDesk. The POST call works just fine in Postman, but of course, I am met with a "Bad Request" error when attempting in Qlik SaaS.
Please view below screenshots to view the FAILED attempt to pull the list of all IDs. I have included the SUCCESSFUL attempt in Postman as the first image.
The syntax for the body was derived from a community article I found marked as an answer to a similar query:
https://community.qlik.com/t5/App-Development/REST-connection-x-www-form-urlencoded/td-p/2085774
It states that you can:
format the request as PowerShell - RestMethod in Postman and then simply Copy Paste the $body content in Qlik.
Please let me know if there is any additional information I can provide.
Hi Support,
We're seeing an issue where shortly after a task starts, there's an error with the message: "The Statistics Log cannot open the file D:\Attunity\Replicate\data\logs\metrics\metricsLog.txt. Error: Access is denied.". Just after this error message appears, the task fails and the GUI console reports that the task has stopped abnormally.
I'd just like to understand if anyone else has seen this before? And if so, how they were able to resolve it. Any assistance/insight would be greatly appreciated
The Replicate version is v2023.5.0.413
Thanks,
Nak
Hello,
Similar to a post here: https://community.qlik.com/t5/New-to-Qlik-Sense/REST-connection-api-limit/m-p/2038360#M224175
We've added our REST to the shopify URL using the below method
https://xxx.myshopify.com/admin/api/2023-10/orders.json?status=any&fields=name,number,order_number,created_at,total_price,total_discounts,total_tax,cancelled_at,contact_email,currency,current_subtotal_price,current_total_discounts,current_total_price,current_total_tax,order_status_url,total_line_items_price,billing_address,customer,line_items
With a header of 'X-Shopify-Access-Token' being set and our token.
However, the API is limited by shopify and it only pulls back 250 records. If you have more than 250 orders, which we have, we need to paginate to pull all orders through.
---
Using Postman, we can achieve this as in the response headers we get;
Key = Link
Value =
"<https://xxxxxx.myshopify.com/admin/api/2023-10/orders.json?fields=name%2Cnumber%2Corder_number%2Ccreated_at%2Ctotal_price%2Ctotal_discounts%2Ctotal_tax%2Ccancelled_at%2Ccontact_email%2Ccurrency%2Ccurrent_subtotal_price%2Ccurrent_total_discounts%2Ccurrent_total_price%2Ccurrent_total_tax%2Corder_status_url%2Ctotal_line_items_price%2Cbilling_address%2Ccustomer%2Cline_items&page_info=eyJzdGF0dXMiOiJhbnkiLCJsYXN0X2lkIjo1NTMzMTIwNzU4MDY4LCJsYXN0X3ZhbHVlIjoiMjAyMy0xMC0xOSAxMToxMzowNy4xMTQyMjUiLCJkaXJlY3Rpb24iOiJuZXh0In0 >; rel="next""
So we would use that URL in the Link value and it would pull the remaining orders.
We are struggling on how we can acheive this through the Qlik Sense Data Connector?
We've tried setting up Pagination Type has 'Next URL' with 'Link' in the 'Next URL Path' and the other methods.
Are we missing something?
I am trying to create a field in a table where each row shows the total number of times a record appears in a table.
every count formula i can think of and try is giving me a value of 1 and not it's total.
I can do this in EXCEL by saying countif(A:A, Criteria). How do i do that in QLIK?
I have configured a Qlik Cloud application to query a Databricks cloud database using "Direct Query" and a custom SQL statement. I've simplified my application down to a single SQL statement and a single table. When the app loads, it uses my SQL statement to fetch the first batch of data, and it is successfully displayed in the table. When I make a selection on the table, the application generates the SQL to filter the table using the selection. Unfortunately, the SQL is not being generated properly and I get an error dialog.
Direct Query mode error: SQL Adaptor error: Connector error: ERROR [42703] [Qlik][Hardy] (80)
Syntax or semantic analysis error thrown in server while executing query.
Error message from server: org.apache.hive.service.cli.HiveSQLException: Error running query:
[UNRESOLVED_COLUMN.WITH_SUGGESTION] org.apache.spark.sql.catalyst.ExtendedAnalysisException:
[UNRESOLVED_COLUMN.WITH_SUGGESTION] A column, variable, or function parameter with name `DDG70`.
In Databricks, I can see the SQL that was generated and submitted. The SQL includes a WHERE clause with "IN (DDG70)" that should be "IN ('DDG70')".
I've simplified the App to just the custom SQL and table to show the issue.
Is there a work around or fix for this? For the complicated case, I need to use custom SQL.
Hi Qlik Experts,
We are planning to update our existing Qlik Sense - Oracle AWS RDS connection by changing the port from 1521 to 2484 and implementing SSL.
Currently, our Qlik Sense - Oracle AWS RDS connection uses port 1521 without SSL.
Could you please provide documentation or steps for making these changes, including SSL implementation?
Thank you!
R
Hi,
How do I handle the qlik auto generated files countryAliases.qvd and countryGeo.qvd when I publish apps or copy apps to a new space?
They seem to only(?) be generated when the data manager is executed/preparing the data and not on reload. Thus when the app is outside the shared development space it produces an error because it can't find the files or don't have access or similar.
Kind regards
Johan
Hi,
I've been a couple hours trying to fix this. This should be simple, not so **bleep** hidden or whatever...
First of all. Where is the QMC? Every topic about this subject has mentioned the QMC, but it seems to not exist in the currently SaaS version.
Basically, I have an app inside a >shared space<. I'm the tenant user, etc, so I do have available the option to publish bookmarks, but for some reason, analyzer users can only create bookmarks, not publish.
I went to to the "Administration" menu (supposely the new QMC) and tweaked the permissions in the "spaces" tab. Also went through the "users" tab, but I can't seem to find anything related to "can publish".
This guide says I need to set "can edit" under the app settings. I've set every "cans" and still no option to publish:
Users just want to be able to see each others bookmarks. Why is this so complicated? Moreover, if Qlik's gonna update their SaaS webpage design so frequently, at least update your documentations in time, so we don't feel stupid looking for something that is no longer available or has changed.
Does anyone know how to fix this?
I have Qlik Replicate version May 2023 (2023.5.0.771).
I see the early builds version 2023.11 and 2024. Which one should I apply?
Please advise.
I have an app with a pivot table that each row is basically it's own specific measure. Currently we set the background color for every other row which is tedious but works. But then if we want to use show if conditions for some rows that can break the manual every other row alternating color. Because each row is its own unique measure each row has a dimensionality of 0 and a RowNo of 1 so I don't think I can use either of those as a base. Are there any other options I am unaware of?
Join us for 3 magical days of learning, networking, and inspiration — and discover new ways to maximize your data’s value.
Seamless Public Data Sharing with Qlik's New Anonymous Access Capability
Fuel your data and AI journey with the right services, delivered by our experts.
With Qlik Answers™, get personalized, GenAI-driven answers from unstructured data, so you can make decisions with confidence. Learn how in our product roadmap keynote and demo.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enhances decision-making with high-speed insights, as Mayborn Group integrates data from various functions across their global operations, gaining a competitive edge in the childcare industry.
Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.
Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!