This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
The process established by the company I work for is that we have the document coming into a MAPPER, that links the incoming fields to the SQL SERVER UPDATE Snap. This tells the UPDATE snap which fields should receive which values, but this includes ...
Normally with our pipelines, if there is an error, we feed the error view document into an email, or a Jira object
We have had a third party create a pipeline recently, and they have not done this
We have had an error over night, and this is telling ...
I’m having an issue with a pipeline, and I’m hoping someone can help me with a solution
The pipeline takes data from 2 different databases, and joins them, looks up from a third system, creates a new field, and thenupdates a field in CRM with that ne...
I’m working on a pipeline that needs to create and send a text file to a third party
That text file contains rows formatted in the same was as a csv file
The file contains a header row, then the data rows, then a footer row
The header and footer row...
Hi
We need to create a text file to send to a third party, but snaplogic does not appear to have the ability to create a text file
I’ve had look at online, and only found 1 post that said to export it into a txt file you need to use a csv formatter
T...
figured it out. the ID field needs to be assigned to $original.IDThe "orginal", which is case sensitive, lifts it into a sub-document in the jsonwhich is then ignored by the SET, but you are still able to include it in the WHERE(I had tried this alre...
With some more investigation, I've found that the tables we have been updating up till now are not declared as IDENTITY in SQL, but rather the third party that created the system have them working functionally as IDENTITY fields, but rather than let ...
Here is an image of the error
I’ve already found online that the issue is probably hat the endpoint was unavailable
But I’m hoping to get an answer to my question, so I now how to check the this in the future
Thanks
Thanks for the try, but it didn’t work.
I modified my pipeline to use your method, and it does the same thing.
The incoming document has a format of:
6 columns
33 columns (multiple rows)
6 columns
And then somewhere between the csv formatter and the ...