Unable to resolve target record, coalesce values not present

[Brian Lancaster]

I'm working with a friend and we are trying to learn rest by dong an incident integration between our personal dev instances.  In my dev instance I have created staging table by going into System Web Services > Inbound > Create new.  When I created it I told it to copy the fields from the target table.  Then I created a transform map with a coalesce field.  When he tries to send anything from his persona dev instance to mine (useing reset message) he get an HTTP status 201 and the response body stats the following.

{"import_set":"ISET0010001","staging_table":"u_dev69_inc","result":[{"transform_map":"Dev69 INC","status":"error","error_message":"Unable to resolve target record, coalesce values not present: u_third_party_ticket; Invalid table ","status_message":"Unable to resolve target record, coalesce values not present: u_third_party_ticket"}]}

When I look at my staging table see a new record inserted in the table but it is completely blank.  Below is his JSON body which I gave him using reset api explorer.

{"u_third_party_ticket":"INC0010005","u_description":"Test, test, test, test, test"}

What are we missing?  I have verified that the account he is using to connect to me has read, write, and create on the staging table.  I have also given this account the following roles (ITIL, reset_service, import_set_loader, import_transform, import_scheduler)

[Brian Lancaster · Accepted solution]

Figured it out.  In the reset message he had 3 variable substitutions but on the  http requests tab he did not have the issuebody variable in the content.  As soon as he added that the records got added with data and the incident was update.