Pass a pipeline parameter to a SOQL
Is there a way to pass a pipeline parameter to a child pipeline which has a SOQL, and use that parameter in the SOQL?
I am trying to output a date field from a parent pipeline and pass it into the ...
Forum Discussion
To view his pipeline, you would need to download it from here and import it into your environment, preferably in a test area.
Got the import option. The query still seems to give me an error. The SOQL query I am using is below:
“SELECT Id ,IsDeleted ,MasterRecordId ,Name ,Type ,RecordTypeId ,ParentId ,BillingStreet ,BillingCity ,BillingState ,BillingPostalCode ,BillingCountry FROM Account WHERE LastModifiedDate >” +$StartTime
and I am passing the StartTime as a string in the required format.
eg. 2019-03-15T19:15:13.067
It gives me a 400 error.
Reason: {‘statusCode’=‘400’, ‘message’=‘The request could not be understood, usually because the JSON or XML body contains an error.’, ‘response’=‘[{“message”:“line 1:0 no viable alternative at character ‘"’”,“errorCode”:“MALFORMED_QUERY”}]’},
It worked. I had new line characters in my SOQL which were giving me the error. I removed those and worked just fine! Thanks all for your help! I really appreciate it. 🙂
