Giter Club home page Giter Club logo

invoices-leanautomation's Introduction

Robocorp project to ingest invoices, send them to docDigitizer, obtain the data from their webservice and save it to an Airtable repository

This project provides support for docDigitizer webService, in order to:

  • Receive / ingest invoices in PDF or any other format
  • Send them to DocDigitizer and obtain a taskID
  • Query DocDigitizer to obtain the documentID related to the taskID
  • Query DocDigitizer again to obtain the document Details

Invoices are also saved and registered into an Airtable repository.

Requirements

An API_KEY is required to work with Airtable and must be included in Control Room:

  • A vault secret must exist called AirTable and must include API_KEY and API_URL
  • The API_KEY is provided by Airtable, in the API documentation. There is no need to include the word Bearer with the API_KEY
  • The API_URL can be obtained after registering into AirTable and replicating the URL-to-Replicate repository
  • After replicating the Invoice environment, Airtable will provide a URL that must be included in the secret. The following is an example URL in our secret: /appAbC123xYz987AZ/Invoices

To operate and work with docDigitizer, an API_KEY is also required and must be included in the Control Room:

  • A secret called DocDigitizer must exists and with the key API_KEY

Tasks

The following tasks are different ways to feed invoices into the system. The most common ways to incorporate invoices into the system are:

  • Reading them from a folder
  • Obtaining them from an email box.

There are two robots that implement these use-cases:

  • Invoices From Folder
  • Invoices From Mailbox

Invoices From Folder

This robot reads the file in a folder and send them to DocDigitizer to obtain the relevant data

Configuration required:

  • "INVOICES_DIR": "Invoices"
  • This variable %{INVOICES_DIR} must be configured in Robocorp Cloud for this step

Invoices From Mailbox

This robot accesses a mailbox, reads emails with a subject including the word "Invoice", and then downloads the attachments to the previous folder.

Configuration required. The following variables must be configured in the Robocorp Cloud for this step :

  • "MAILSERVER": "imap.server.com"
  • "MAILPORT": "xyz",
  • "MAILBOX": "[email protected]"
  • "INVOICES_DIR": "Invoices"

Invoices From AirTable

Use this task if your users upload invoices directly to Airtable. Those invoices are retrieved from Airtable, the PDF file is downloaded, and a request with that invoice file is then sent to DocDigitizer.

Scheduled Tasks

Once invoices are sent to DocDigitizer, two tasks are executed under an schedule:

  • Invoices Update DocumentID in AirTable
  • Invoices Update Document Details in AirTable

API access to ROBOTS

Two tasks are provided to be used as an API

Send Invoice to docDigitizer

  • Send Invoice to docDigitizer

The payload to make use of this web service is as follows:

"payload": {
    "invoiceName": "invoice_filename.pdf",
    "invoiceId": "idCreatio-xxxx-yyyy",
    "urlCreatio": "https://host:port/path",
  	  "invoiceContent": base64content
}

Get invoice Details

  • Get Details from docDigitizer Invoice

    "payload": { "documentID": "xxxxxxxx-yyyy-zzzz-aaaa-kkkkkkkkkkkk" }

invoices-leanautomation's People

Contributors

joseferrerh avatar

Stargazers

 avatar

Watchers

 avatar

invoices-leanautomation's Issues

Improvements to "about" description of the repo

Hi @joseferrerh. Greetings from Robocorp, and thanks for contributing to the community of digital workers! :)

I noticed the About description of the repository is not optimal. Because the Portal pulls in the description from "About", it ends up looking like this:

image

We suggest improving the about description in the repo so that it is a short and clear complete sentence. Thank you!

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.