using REST with flexicapture

  • 43 Views
  • Last Post 12 hours ago
cristian ascencio posted this 5 days ago

Hello again:

I Have this actual scenario:

 

1)  have a database  with a table that contains  this fields:

   id_number,firstname,lastname,gender, date_of_Birth (12.000 rows aprox)

2)  my  document definition allows me to capture the  id_number  from the document itself (OCR) and a  script rule checks if that captured  number is present in the database, if it is true. the rule fills the  firstname,lastname,gender, date_of_Birth  fields in a table element (please take a look to the attached files so you can see what i am talking about)

I am interested to know if it could be possible  to use some REST web service With flexicapture in order to  consume  it  so i can  get that info from my database instead of using a  script that connects directly to the datasource

pd: Im using  javascript for my  custom rule.

Thank u again for your help!

Order By: Standard | Newest | Votes
Vladimir Dimitrijevic posted this 5 days ago

Hi Cristian,

It can be even faster if you check the values against the dataset from your script rule, because there is no external call to the database. You will only have to set that datasets are updated regularly.

 

Best regards,

Vladimir

cristian ascencio posted this 4 days ago

oh.. well im not sure if i  get it  right...you suggest me not to use a web service 

and just keep using what i am using?

 

Vladimir Dimitrijevic posted this yesterday

Hi Cristian,

I am not sure how you compare data against the database, since you are saying you are using script to connect directly to data source. Some developers are using external dll's to connect directly to database, and in this case could be better solution to use Dataset (Project setup station -> Document Definition Properties -> Datasets tab).

For only 12.000 rows it has no sense to develop external component to check against database. You can connect Dataset to database and check your data against the dataset, it is simpler solution and also faster.

I had tasks where I needed web service, but for task you have- it is really not necessary. 

 

Best regards,

Vladimir

cristian ascencio posted this 20 hours ago

Hi Vladimir.!  you are so right,  the real database will have more than 94 millions of records. so thats why we are interested in develop some REST service to get the info:

Please, take a look to the attached file so you can see how it is working so far

 

Please let me know if for that ammount it could be an option to use datasets.

 

Attached Files

cristian ascencio posted this 19 hours ago

Just one think.. our customer has that big database (its not ours) so they need us to connect to it using that web service i am talking about.

 

  thank u for your support

Vladimir Dimitrijevic posted this 19 hours ago

Hi Cristian,

For that amount you cannot use datasets for sure. Will get back you on this, hope tomorrow.

Best regards,
Vladimir

mfeldman posted this 12 hours ago

Hi Vladimir,

Using FC 11 Standalone.
Question about dataset refresh rate.
I've set it to 4 hours.
Typically, FC Standalone is not active when there is nothing to do, like overnight

Will the dataset be refreshed in the morning when FC is first started for the day?

Thx,
M.

 

Close