Jarek
New Contributor
Joined 8 years ago
User Profile
User Widgets
Contributions
Snaplogic Generic JDBC
Hello, I’m having a small problem with the timestamp between the results coming from Snaplogic Generic JDBC and SQL Teradata SQL assistant. Main issue is that the timestamp in Snaplogic results shows a different time compared to Teradata SQL assistant. Could you please let me know what I need to change on the Snaplogic side in order to match the timestamp results. Same query used in both places. The format is irrelevant just want to have same date and time e.g. 1st of OCT 2021 00:00:07 instead of 05:00:07 (as in Snaplogic results). Best Regards, Jarek2.6KViews0likes2CommentsPipeline to save the attachments
Hi, I’m having a problem with creating a successful pipeline that uses REST GET (Coupa system) and saves the attachment file (pdf) to either NetSuite file cabinet or even to file server of Snaplogic. Long story short, I have the url of the file and I’m trying to put that url to File Reader snap, later (if my logic is correct) use the Binary to Document, after that use File Writer. I tried to skip the Binary to Document snap but that didn’t work either. I know for sure the url is correct, I just cannot move forward from that point. I would be extremely grateful for any suggestions that may lead to success 🙂 Best Regards, Jarek1.1KViews0likes0CommentsRe: Netsuite Account Setup
Hi Brian, Hi Patrick, I was using credential based authorization but just received a warning message from NetSuite, therefore I’m back with the TBA account for REST snap. I’m fighting with the account settings ☹️ For this particular search I need to use RESTLet, I was thinking about running the SQL query but after some research I couldn’t find the Last Login Date table in the NS Database.896Views0likes4CommentsRe: Netsuite Account Setup
Hi ptaylor, I prepared a saved search within NS that returns list of employees with access (roles assigned) and their login date. When I tried to pass the info everything was there (using NS snap) except the last login date. I had to use the script that runs this search. I was able to use the NL Authorization within header and obtain the data, but leaving the login and password within the REST GET snap is not the ideal approach. (please find enclosed print screen - acc ID is of course fake in the PS). Best Regards, Jarek1.6KViews0likes2CommentsRe: Netsuite Account Setup
Hi, I’m struggling with setting up the REST account for NetSuite (TBA). I’m not quite sure what I should enter for Oauth1 and Oauth2 when it comes to endpoints. Have you had any luck with setting up the proper account for the REST ? FYI - I’m trying to access a script that runs a specific saved search, the results of the saved search are not available via NetSuite search snap. Regards, Jarek1.6KViews0likes4CommentsRe: Snaplogic Netsuite - Search snap
Hi Patrick, My bad, I was referring to the older version. In the very document that you provided me with (latest) there is this one information that solves the issue - currency revaluation is not available on WSDL (print screen enclosed) My apologies for bothering you and thank you for the support. Best Regards, Jarek869Views0likes0CommentsRe: Snaplogic Netsuite - Search snap
Hi Patrick, Thank you for investigating the issue. As a matter of fact the Currency Revaluation is among the list of SuiteTalk Web Services (page 365 and 370 of latest SuiteTalk) /app/accounting/transactions/fxreval.nl? Additionally I’m enclosing the print screen from NS saved searches (brand new one, not the one I used for the snaplogic) Thank you, Jarek2.8KViews0likes0CommentsSnaplogic Netsuite - Search snap
Hi Everyone, I’m trying to obtain the data from already existing Netsuite saved search that contains only Currency Revaluation type of transaction. Sadly when I run the pipeline I got zero results while on NS side I’ve got dozens (I narrow the result to only one accounting period), it seems this type of transaction is not available in the snap as a separate category or under Transactions. Does anyone know how to obtain currency revaluation transactions via snaplogic ? I really don’t want to struggle with SOAP execute snap as I’m not that good with coding. Just for the record, I did try all the available combinations of NS Search, meaning with or without the flag on: Body Fields Only, Advanced, Return Search Columns. Best Regards, Jarek4.6KViews0likes7Comments