Update into Bigquery table using Apigee X integration

[deepaksoni7]

Hi team , I am trying to execute one integration where I have to update the bigquery table using the Apigee integration . Not able to configure the value for filterClause  giving below  error .

Unrecognized name: CASE123456 at [1:633]\\\",\\\"conditions\\\":\\\"CaseID=CASE123456\\\",\\\"connection_type\\\":\\\"Bigquery\\\",\\\"entity_type\\\":\\\"table_dummy\\\"}}],\\\"message\\\":\\\"Unable to update

I am trying to update table based on the CaseID and used the below configuration .

looking for some guidance or samples

[AlexET]

Hi @deepaksoni7, thank you for your question 🙂 We’ll monitor your post to ensure it receives the attention it deserves. In the meantime, we encourage other community members to share their insights.

Alternatively, we would love for you to join us at our weekly office hours every Thursday at 4 PM CET (10 AM EST | 9 AM CST | 7 AM PST). We look forward to seeing you this Thursday for more in-depth discussions. If you’re interested, you can register here.

[lalevee]

Hello @deepaksoni7 

It seems that BQ caseID column is a string, correct ?
In this case, you have to add quotes in the expression, something like:

"CaseID = '"
.CONCAT(api_request_body.CaseID)
.CONCAT("'")