Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • Troubleshooting
  • Salesforce error: Could not find any records of "inscor_Repair_Order_Line_c" object: Salesforce returned a MALFORMED_QUERY.

GM All, 

I am new to the zapier world, and I recently picked up a project where we are using DocParser to automatically update records with a zapier flow to our salesforce. I’m using two find record actions on my flow for the necessary information in Salesforce which both pass testing, but in my fourth step using a SOQL to find the record we intend on updating, it errors on a malfunctioned query and does not pass. 

The query error is Failing to find record, I am confused because the ID #s both are found in prior steps, so I think that something must be wrong with my SOQL. Any suggestions would be appreciated, TIA!

 

 

Hi @itscade 

Good question.

You may be missing quotes around the values.

 

Use the Find Object by Query Search

Tips for building a SOQL WHERE clause for your search:

  • Confirm all fields included in your query have appropriate field accessibility and aren’t hidden.
  • Fields names don’t have to be wrapped with quotation marks.
  • Field values should usually be inside single quotation marks (e.g. 'John Doe').
  • Avoid using double quotation marks (").

WHERE clause examples:

  • Name = 'John Doe' AND Status = 'Active'
  • CreatedDate > 2011-04-26T10:00:00:08:00
  • Name LIKE 'A%'

Thanks, @Troy Tessalone , added to both values but test is still not passing. I think I’m going to have to reevaluate the objects I’m testing with

@itscade

We’d need to see updated screenshots with how your Zap step is configured.

Hi @itscade 

Let us know how it goes!

@Troy Tessalone can do. 

First Action is the information pulled from DP for all RO specific salesforce IDs

Second Find Action -

Third Find Action - 

Fourth find is the query to RO # and Part Number salesforce ID from the salesforce record referenced at the original thread

@itscade

We’d need to see updated screenshots with how your Salesforce step is configured now with the adjusted query.

@Troy Tessalone 

like such?

@itscade 

You mentioned that you updated the query in Zap Step 4, but are still encountering an error, so we are asking to see updated screenshots with how that Zap Step 4 is now configured.

 

 

You may be missing quotes around the values.

 

Use the Find Object by Query Search

Tips for building a SOQL WHERE clause for your search:

  • Confirm all fields included in your query have appropriate field accessibility and aren’t hidden.
  • Fields names don’t have to be wrapped with quotation marks.
  • Field values should usually be inside single quotation marks (e.g. 'John Doe').
  • Avoid using double quotation marks (").

WHERE clause examples:

  • Name = 'John Doe' AND Status = 'Active'
  • CreatedDate > 2011-04-26T10:00:00:08:00
  • Name LIKE 'A%'

@Troy Tessalone Apologies

 

@itscade 

The single quotes should be only around the dynamic variables.

 

Use the Find Object by Query Search

Tips for building a SOQL WHERE clause for your search:

  • Confirm all fields included in your query have appropriate field accessibility and aren’t hidden.
  • Fields names don’t have to be wrapped with quotation marks.
  • Field values should usually be inside single quotation marks (e.g. 'John Doe').
  • Avoid using double quotation marks (").

WHERE clause examples:

  • Name = 'John Doe' AND Status = 'Active'
  • CreatedDate > 2011-04-26T10:00:00:08:00
  • Name LIKE 'A%'

@Troy Tessalone I see, my mistake

still receiving error, even though both of these values are in the object I’m looking for, do I need to add a third find record in salesforce action for the Repair Order Line? 

@itscade 

Try removing all the ( and )

Also, you may need to pass in the Object name instead of the Object ID as part of the query.

Terms & Conditions