fvalidateRequest

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.

Arguments

Parameter	Type	Description
@proofId	VARCHAR	ProofId from an anchor request. The proofId can be found in the PROVENDBREQUESTS table and also in the PROVENDBCONTROL table

Returns

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

Example

SQL

1> select proofid from provendbrequests where id=1
2> go
proofid                                                                                                                                                                                                                                                         
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
df3f85292c2cbc2bcad8830c9f33d0745282c8dceb6aceb013ff1b13c9315f5a:NKXi-cDlpLdYXjaHjCFAw                                                                                                                                                                          

(1 rows affected)

1> exec [dbo].[fvalidaterequest] "df3f85292c2cbc2bcad8830c9f33d0745282c8dceb6aceb013ff1b13c9315f5a:NKXi-cDlpLdYXjaHjCFAw"
2> go

(1 rows affected)
                                        
----------------------------------------
                                       2

(1 rows affected)

1> select status,messages from provendbRequests where id=2;
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"]