ariana
New Contributor
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: How to bring API JSON text into REST Post Snap?
The error view output tells the same story, that it is forbidden. We are asking another engineer who has worked on external APIs as well. We aren’t sure if it is a security/whitelisting issue. I appreciate your help. I might get back here for questions again if there is anything else on the SnapLogic side.1.4KViews0likes0CommentsRe: How to bring API JSON text into REST Post Snap?
ptaylor: $entity to JSON.stringify($entity Hi ptaylor, thank you for the addition. Do I need to change any other settings if doing that? I am not getting output still ☹️ This is the preview I get when I hover over stringify- is that what I would want?3.8KViews0likes0CommentsRe: How to bring API JSON text into REST Post Snap?
Hi there! Thanks for your help. Here is what I am looking at now, still no output: Mapper - Mapper validation output - POST Snap: Pipeline: Edit: I will add that I did try simply copying the body into the mapper with “$” in the Post snap but with the same (lack of) results.3.8KViews0likes6CommentsHow to bring API JSON text into REST Post Snap?
Hi all, I am trying to use a JSON file to feed in the body of a response that is working in Postman with curl code like this: In SnapLogic I added the raw body in a JSON generator and want to feed that into a REST Post Snap. My pipeline looks like this: With no headers nor queries in Postman, only the JSON/raw body and the service URL, I retrieve results with no issues. However, with Snaplogic I am not receiving output. Has anyone done this? I am told I cannot incorporate the credentials into the headers, it must be in the body…but how do I reconcile this with SnapLogic? No one on my team has worked on something externalized that has functioned in this way. Thanks!6.3KViews0likes8CommentsHow would I use Python scripts to transform data from CSVs or Oracle?
Hi all, I need to transform data in ways that I would typically use pandas or a similar package for. It is manipulation of the data itself with joins, transformations, etc. It would be nice to be able to bring in the data directly from Oracle, join what I need, run a script for most of the transformations in Python, map, and then insert into a new table. Running a script is where I struggle. Are there any examples of how I would go about incorporating the transformation with a Script snap? I have read up on the Remote Python Executor but I’m not sure if that is an option for our business (I do not see it in designer). In Python I would simply write a script that pulls in the data, does the transformation, and exports, but we want to use SnapLogic to automate the process. How do I incorporate it and how would I start off the script to read in my data post-join (or wherever I leave it off in the prior snap)? What snap is typically used before a script, if that matters? Any advice on doing this or resources would be much appreciated. I am new to ETL tools so this is a big jump from writing POCs in Python for me! Cheers!2KViews0likes0Comments