What is your goal?
Hi everyone,
I’m having trouble with the Kintone “Search Records” module and getting a [400] error:" (Input is incorrect. Query syntax is wrong.)
My scenario:
Kintone - Watch Records (triggers on new contact)
Salesforce - Upsert a Record (creates/updates account)
Kintone - Search Records (trying to find matching records by AccountName)
The problem:
In the Kintone Search Records module, I’m trying to query records where the AccountName field matches a value from a previous step.
Current setup:
Field: AccountName (typed as text)
Comparison operator: =
Value: {{2.Account Name: Value}} (mapped from Watch Records step)
What I see in the INPUT:
Query: (Array)
1 (Array)
1 (Collection)
a: AccountName
b: Maeda Steel Co., Ltd.
o: =
This array format {a, b, o} causes the [400] error.
My questions:
How do I enter a plain text query like AccountName = “value” where AccountName is a field in the current module.
Any help would be greatly appreciated!
What is the problem & what have you tried?
I can get all records, and then filter but that seems to be a waste. I want to query only the necessary records.