fvalidateRequestId

The fvalidateRequest procedure validates the data for a proof. It reconstructs the merkle tree for the data specified in the proof, and lists any rows that have been added, modified or deleted. It also checks that the root hash for the merkle tree is unchanged and that the blockchain anchor is intact.

This procedure is similar to fvalidaterequest but takes a requestId rather than a proofId.

Arguments

ParameterTypeDescription
@requestIdNUMBERThe identifier for an anchor request as found in the PROVENDBREQUESTS table

Returns

The request identifier which can be used to lookup the rows in the PROVENDBREQUESTS table.

Example

1> 1> select requesttype,status from provendbrequests where id=1
2> go
requesttype  status      
------------ ------------
ANCHOR       SUCCESS     

(1 rows affected)
1> EXEC [dbo].[fvalidaterequestId] 1
2> go

(1 rows affected)
                                        
----------------------------------------
                                       3

(1 rows affected)
1> select status,messages from provendbRequests where id=3;
2> go
status       messages                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
------------ --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SUCCESS      ["PASS: Validated all data hashes for df3f85292c2cbc2bcad8830c9f33d0745282c8dceb6aceb013ff1b13c9315f5a:NKXi-cDlpLdYXjaHjCFAw","PASS: Proof validated with hash df3f85292c2cbc2bcad8830c9f33d0745282c8dceb6aceb013ff1b13c9315f5a on https://testnet.dragonglass.me/hedera/search?q=57a60347107b0bf812b2639060f60fa49c0f97dfc00803c09fe462afffd644f1c859b54e92e059195ee52345c661618e"]