Hi TX Support,
We're encountering a strange issue. We've setup an deliver instance of the REST API endpoint type. The model contains a dimension table. In the MDW layer this table contains 7844 records. Now when we pull the data from the REST endpoint we get 7844 as well, however the content is incorrect. Instead of the 7844 individual records we get 6974 records, 870 of those are duplicated and consequently 870 other records are missing.
Example:
DIM_Location Table
Location, Code, DW_Id
Original MDW data
LocationA, 123, 1
LocationB, 345, 2
LocationC, 678, 3
REST data
LocationA, 123, 1
LocationB, 345, 2
LocationB, 345, 2
Missing Record in the REST data
LocationC, 678, 3
Now I did tried everything I could think of in terms of troubleshooting. Everything is deployed, executed, refreshed and running. Going through the data I made an important observation. The set that is duplicated all are records that reside on the first page. They are then duplicated across the remaining pages. See the screenshot of the 870 duplicated records and their distribution.
Do you have any ideas and/or suggestions on how to solve this issue?
For clarification: we are able to replicate the issue in both Qlik and Postman with the original table and a new test table.
Hilsner,
Luuk
