mbostrom_dtiq
New Contributor II
Joined 7 years ago
User Profile
User Widgets
Contributions
Re: REST POST A File?
@christwr did you ever find a solution here? i have a file on AWS S3 and need to include that into an API with an attachment parameter. but the API keeps telling me “{“message”:“The given data was invalid.”,“errors”:{“attachment”:[“The attachment must be a file.”]}}”. not sure how to post a file the correct way from snap after it reads it.1.4KViews0likes0CommentsRe: Salesforce SnapPack with "Content" as opposed to "Attachments"?
i am able to get the content version using the saleforce rest api with snaplogic. you need to create a connected app and use the consumer secret and id along with login creds. however when i get the contentversion it comes back as entity base64. i’ve tried various things to decode it with no luck. has anyone been able to retrieve the actual doc from the sfdc content version?2.3KViews0likes0CommentsGenerate sequence of dates between 2 dates
i have a requirement to “fill in the gaps in time” per se on data from a system. Here is my use case: A customer signed up with the company for $100 subscription monthly for 3 years. The company added services 6 months into the contract which bumped their subscription up to $120 / month, and again a couple months later. but then never again for a couple years. however our ERP only shows the effective dates based on the change. so the json from the system would look this this but I need to create records for every missing month using the previous month if no changes were made. Then when the next change made use that and generate the missing time between that month and subsequent months until the last change. this will allow us to show trending over time and the revenue for that customer by every month in which they have been a customer. what is the best way to achieve this? a parent customer can have multiple locations in which this could change for this example i’ve simplified it to just 1 customer with multiple records so i believe some level of grouping and min/max dates need to be used. [ { “Parent_Customer_Id”: 12345, “Location_Site_ID”: 98765, “Parent_Customer_Name”: “Acme”, “Business_Name”: “Acme Store 1”, “Monthly_Change_Tracking_Id”: 7, “Effective_Date”: “2015-12-16T00:00:00.000”, “Monthly_Revenue”: 100 }, { “Parent_Customer_Id”: 12345, “Location_Site_ID”: 98765, “Parent_Customer_Name”: “Acme”, “Business_Name”: “Acme Store 1”, “Monthly_Change_Tracking_Id”: 21, “Effective_Date”: “2016-06-16T00:00:00.000”, “Monthly_Revenue”: 120 }, { “Parent_Customer_Id”: 12345, “Location_Site_ID”: 98765, “Parent_Customer_Name”: “Acme”, “Business_Name”: “Acme Store 1”, “Monthly_Change_Tracking_Id”: 44, “Effective_Date”: “2016-08-16T00:00:00.000”, “Monthly_Revenue”: 130 }, { “Parent_Customer_Id”: 12345, “Location_Site_ID”: 98765, “Parent_Customer_Name”: “Acme”, “Business_Name”: “Acme Store 1”, “Monthly_Change_Tracking_Id”: 55, “Effective_Date”: “2020-12-16T00:00:00.000”, “Monthly_Revenue”: 150 } ]3KViews0likes2CommentsEval method behaving strangely
Hello. This is very strange but we have a pipeline that has pipeline parameters / arguments. 1 for month and the other year: This works fine when the months is 7 or less (july). once you put the param = 08 for august and year 2020 this strange error occurs. we are using the eval() method and mapping eval(_month) to month variable and eval(_year) to year variable. this makes absolutely no sense! Using 07 2020 there are no errors or any months prior to it: What gives?2KViews0likes2CommentsRe: Rest GET Poller
ok i tried adding a filter after the Rest Get but now its just stopping b/c no documents are going through. could it be something related to me “validating” the pipeline and not executing and maybe snaplogic is having a caching issue on the Has Next retries? i don’t observe the snap actually waiting and have tried the Pagination Interval at 30 seconds. would expect that snap to take longer but its cruising through quickly:3KViews0likes0CommentsRest GET Poller
Hi all, We are integrating SnapLogic with Zendesk. The Zendesk API creates a JSON job which tells the status of the job for various requests made to the API. However using the REST GET snap to get the JSON job runs too quickly and the job status is still “In Progress”. However I need to error handle an error after the job is completed and also alert on a success. How do we have SnapLogic wait and continue to try that job JSON URL until it gets a success or error? I see a Retry parameter on the snap but i think that is just for handling exceptions and the result is coming back ok. The Salesforce Poller snap handles this similarly but that is not available.5.3KViews0likes6CommentsMaking an array with JSON
Hi all, I’m building an integration do DocuSign but when I use the JSON Generator it works fine and looks like this: Notice how the templateRoles has an “[” within the JSON specifying some array with the JSON: When I use a mapper to try and create this JSON in that format it outputs it without the brackets and causes an API issue as it expects an array within that templateRoles section. Here is my mapper: Now check out the output of the mapper how it does NOT have the brackets embedded within that in the templateRoles node: What do I need to do to get the output in the same format as the JSON generator?3.3KViews0likes1Comment