Designing and Running Pipelines

How to get JSON node which cause Workday webservice error under Workday Write response message?

Hi Everyone, In SOAP UI/ Workday Studio’s SOAP response, we usually get Web Service(WS) error xpath which tell us the node/XML xpath cause webservice error. This xpath allow developer to understand which section of WS request cause the error. Example...

How to combine csv files

Greetings, I have 3 different csv files that i need to combine into a single one combining their columns. I am trying to use a join snap but got the following error

Exporting text file with CSV formatting, but with different numbers of fields

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...

HTTP Code: 500 Status: Prepare failed Errors

Hi all, We are facing Error "500 Status: Prepare failed Errors"while creating some Netsuite application,below is the screenshot,please help me on this issue. Thanks, Anil

Resolved! I wanted to create multiple arrays from a single array based on specific Field

I have the below input: “AT_Pricehash”: [ { "@TermsListID": "Test1", "ORGID":"1000", "@MinimumQuantity": 1 }, { "@TermsListID": "Test2", "ORGID":"1001", "@MinimumQuantity": 1 }, { "@TermsListID": "Test3", ...

How to pass HTTP codes in JSON output

Hi, I have a JSON like below, have to pass the value of StatusCode into HTTP Header. I am using JSON Formatter, but incase of Failure also it gives 200 with the actual code in the JSON payload. Help me in how to handle this JSON: { “StatusCode”:“500...

Sender Email error - Username and Password not accepted

Hi Team, I am getting below error in Email sender snap. I added gmail account for receiving email. Can you please help? Reason: Failed to send email message: 535-5.7.8 Username and Password not accepted. Learn more at 535 5.7.8 Check Gmail through o...

Match operator: match object key with special characters

Hi all, I’m facing and issue where i would like to match some properties of an object within an array and then select a specific object key for the result. Since my source data is Workday XML, I have namespaces prepended to the object keys. In this m...

SnapLogic - Integration Nation

Forum Posts

How to get JSON node which cause Workday webservice error under Workday Write response message?

How to combine csv files

Exporting text file with CSV formatting, but with different numbers of fields

HTTP Code: 500 Status: Prepare failed Errors

Resolved! I wanted to create multiple arrays from a single array based on specific Field

How to pass HTTP codes in JSON output

Sender Email error - Username and Password not accepted

Match operator: match object key with special characters

What account should be used for API with query par...

How to dynamically update an account?

Execute each child pipeline multiple times

Routing files from S3

Clean duplicated lines in CSV datasource

How to get all values of a key from objects in a l...

The "Pipeline execute" is changing data types?

Remove XML duplicate key from JSON list in XML for...

Generating individual files based on 'n' records f...

Convert array with objects into object with key/va...