Integrating ServiceNow and ClickUp via Zapier getting errors

[Koteshm]

Hi, we are trying to Integrating ServiceNow and ClickUp via Zapier we are getting errors while selecting the servicenow sc_req_item table. Errors are showing like this "The ServiceNow Create Record action is failing because the prereq field is being populated with a formula reference ({{=gives[\"369784519\"][\"task\"][\"description\"]}}) that isn't being properly resolved. This syntax appears to be invalid for ServiceNow's API, which expects either a direct value or a properly formatted Zapier field reference. Additionally, some of the date fields may have formatting issues or the referenced data from the previous ClickUp step may not be available in the expected format.

How to fix it:

Remove or fix the formula reference in the prereq field - Replace {{=gives[\"369784519\"][\"task\"][\"description\"]}} with a direct field mapping from the previous ClickUp step. Use the standard Zapier field picker to select the appropriate ClickUp task field (such as "Description" from the previous step's task output).

Verify all date field formats - Ensure that DATE::u_delivery_date and DATE::due_date are in the correct format that ServiceNow expects (typically YYYY-MM-DD). Check your ServiceNow instance's field requirements for these custom date fields.

Test the previous ClickUp step - Confirm that the ClickUp "New Task" step is outputting all expected data, particularly the task description field that you're trying to reference in the prereq field.

Map fields using the Zapier field picker - Instead of manually entering formula syntax, click on each field in the ServiceNow action and use Zapier's field picker to select the correct data from previous steps.

Check ServiceNow field requirements - Verify that all required fields in the sc_req_item table are being populated with valid values and that custom fields like u_delivery_date and u_allocation_description accept the data types you're sending."

[Suryansh Verma]

Hello @Koteshm 

Based on the information provided by you, the immediate error may be caused by the manually entered Zapier expression in the prereq field. Remove {{=gives[...]}} and map the ClickUp Description field using Zapier’s field picker. Also format the date values before passing them to ServiceNow.

More importantly, avoid using the Zapier Create Record action directly on sc_req_item when the intention is to submit a catalog item. Use Zapier’s ServiceNow API Request action and call:

POST /api/sn_sc/servicecatalog/items/<catalog_item_sys_id>/order_now

Pass the catalog values under the variables object. If prereq, u_delivery_date and u_allocation_description are catalog variables, they are not direct fields on sc_req_item and must be submitted through the Service Catalog API.

Use ServiceNow user sys_id values for reference inputs, format Date variables as yyyy-MM-dd, and first validate the complete payload through REST API Explorer.

If it is helpful, please mark it as helpful and accept the correct solution by referring to this solution in the future, it will be helpful to them.