chmurray88
New Contributor II
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: PostgreSQL - Execute Snap
that’s not the point…I want to have 1 or more CTEs building different sets of records and then select from that. this is basic query functionality. I want @Snaplogic to either ack they don’t support, show us how it’s supported, or see it on a roadmap.3.9KViews0likes0CommentsSnapLogic Dashboard
Is there an option to add Project Space and/or Project to the Dashboard? It's nice seeing the pipeline, but I'm looking to see Project Space and/or Project also. We have some pipelines with the same names and the only way I know to see which pipeline for what project is to filter on the "Show Only". - ChrisSolved1.8KViews0likes1CommentRe: HTTP client
maheswara - ddellsperger was able to help me get this resolved. If you do not have an offset, limit, or start in the JSON response anywhere AND the pagination type is "cursor", you can do the following settings in your HTTP snap and this will get you all the records. - Has next: $entity.records.length != 0 (your $entity.records might be different depending on how your JSON response looks. This is just the location where your data is located) - check the check box for "Reuse request parameters." - Override parameters: my API had a query parameter called objectsBefore that I could use. For the name I did objectsBefore, value was $entity.records[$entity.records.length - 1].id (basically what this is doing is getting the LAST record in the array and using that as the objectsBefore value then to page to the next set of records) - Chris2KViews0likes0CommentsRe: HTTP client
Thanks for the reply ddellsperger . Odd that I didn't get a email notification with your update. I checked the notification settings and they all look right. Odd. Anyways...I tried the above and there is no paging "level" in my response...it just goes $entity.records....I've emailed the guys that built the API to ask them about a cursor parameter as their documentation doesn't mention one. I will circle back.2KViews0likes2CommentsRe: HTTP client
ddellsperger - How does the above work if there is no offset param? I'm following your post, but I'm not sure how to build the Next URI link when there is no offset option for me. I've been told the API I'm pulling from supports "cursor-style" pagination. No offset, limit, or start.... Any help on this would be greatly appreciated! Chris5.2KViews0likes5Comments
Groups
Partner User Group
This area is for our partners to communicate with each other and with the SnapLogic Alliances team.0 Posts
