Assigning a number to custom table record via Web service:

Experts,

I have a custom table, which is getting populated via the HP Connect-It SM web services connector.
The unique key in the custom table is 'cu.number' (char field).

I have created the extaccess record for this table and

the action is 'add'
Label : create
Allowed action: Create Only

Under the expression tab, I have added the below condition , so I could assign the number when the record is created

cleanup($cu.inc.no);$cu.inc.no=""
$L.void=rtecall("getnumber", $L.rc, $cu.inc.no, "cuIncoming")
cu.number in $L.file=$cu.inc.no


But this is method is not working out. It giving me error code 71 "validation failed'.

Is there any other way to assign the number to the record. ?

Thx

Parents
  • Based on your other post it looks like it is working, at least the reponse has this number which you could verify as having been created by your getnumber call:

    <Number type="String">UB-IM-1027</Number>

    I don't think your 71 error code is related to a bad Number.

    Do you have anything set in the datadict record for your custom table as far as mandatory fields or validations?

     

     


  • The table is a new one. It doesnt have any validation in place.
    I am testing the intial insert into this custom table. If I remove these expressions and hardcode the value, it inserts successfully.

Reply Children