About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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

Salesforce error: Could not find any records of "inscor_Repair_Order_Line_c" object: Salesforce returned a MALFORMED_QUERY.

itscade

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!

 

 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

12 replies

Troy Tessalone
Userlevel 7
Badge +14

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%'
⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
itscade

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

Troy Tessalone
Userlevel 7
Badge +14

@itscade

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

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Brem
Userlevel 4
Badge +6

Hi @itscade 

Let us know how it goes!

itscade

@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

Troy Tessalone
Userlevel 7
Badge +14

@itscade

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

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
itscade

@Troy Tessalone 

like such?

Troy Tessalone
Userlevel 7
Badge +14

@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 - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
itscade

@Troy Tessalone Apologies

 

Troy Tessalone
Userlevel 7
Badge +14

@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 - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
itscade

@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? 

Troy Tessalone
Userlevel 7
Badge +14

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

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Terms & Conditions