Community

using REST with flexicapture

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!

Was this article helpful?

0 out of 0 found this helpful

Comments

9 comments

  • Avatar
    Vladimir Dimitrijević

    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

    0
  • Avatar
    cristian ascencio

    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?

     

    0
  • Avatar
    Vladimir Dimitrijević

    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

    0
  • Avatar
    cristian ascencio

    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.

     

    0
  • Avatar
    cristian ascencio

    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

    0
  • Avatar
    Vladimir Dimitrijević

    Hi Cristian,

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

    Best regards,
    Vladimir

    0
  • Avatar
    mfeldman

    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.

     

    0
  • Avatar
    Vladimir Dimitrijević

    Hi Cristian,

    We stopped using web service on our project 7 months ago. We decided to use direct access to database instead of using web service because it was a bit slower. It is up to you, you could do some tests just to be sure if direct access is significantly faster than web service.

    Best regards
    Vladimir

    0
  • Avatar
    cristian ascencio

    yeah. we would really like to make those tests just to be sure that in our context  should be better to use direct access as you do. so. i´d be more than thankful  if you could provide us some example about how to  deploy a web service  with fc

     

    thank u again!

    0

Please sign in to leave a comment.