debra_paponette
New Contributor
Joined 8 years ago
User Profile
User Widgets
Contributions
Duplicate data using SQL offset
We are attempting to load transactional tables on a pipeline we created Issue faced - While loading data from a transactional table by leveraging the help of limit and offset in SQL SERVER select snap (partition and loading), we are getting duplicate records on the destination table. Cause expected – While loading data, since the source table is getting updated(insertion, deletion and updates) limit and offset values may change with the data mapping, resulting in duplication of reads. We looked at the documentation to understand how the offset feature works but not much data there. Can someone share some further insight on this feature and how it works that may be contributing to the above issue2.2KViews0likes0CommentsRe: 401 Error using Https in API REST GET call
yes It works using the http however the application that provided this API have been upgraded in our test environment and requires the use of HTTPS going forward. Our production environment needs to be updated but can’t because the current pipelines there that uses the APIs (HTTP) will stop working once we upgrade817Views0likes4CommentsRe: 401 Error using Https in API REST GET call
See attached success from browser and postman as well as errror from snaplogic Note that all three instances uses windows AD to access the API and is the same user tested on all three. Both postman and browser is successful. Rest snap complains about it be unauthorised, which is not true1.2KViews0likes8CommentsRe: 401 Error using Https in API REST GET call
Hey, I would also like to understand why I am having issues using the rest snap which is not working once i use API generated from a third party SDK that now only uses HTTPS eg: https://OurServer/ServiceName/Sericves.svc/getInfo?filter=filter before the third party application upgraded we were able to use the rest snap as it was using HTTP eg: http://OurServer/ServiceName/Sericves.svc/getInfo?filter=filter Note the HTTPS links works in other applications, the browser and postman but not in snaplogic.707Views0likes3Comments