vat | PHP library for dealing with European VAT

Here is a solution using the tidyverse which pipes together different stringr functions to clean the string, before having readr read it, basically as a CSV:

You do not need to fetch the Items not the invoice_number of the Invoice. You only need to pass the invoices of the user_profile, and it might be better to also prefetch the Items:

1. Here you are running with a loop for 3 vat values.
   After the first click on the search button the result page is presented.
   There is no search input field and search button there!
   So, in order to perform a new search you need to get back to the previous page after getting the data on the result page.
2. There is no need to create a new instance of web driver each iteration.
3. Also, you should use Expected Conditions explicit waits instead of hardcoded pauses.
   This should work better:

you need to remove parenthesis and comma in - if (!(Contains($_, $excludeList))) { $_ }

you have a problem with passing argument to a function. look here: How do I pass multiple parameters into a function in PowerShell?

You can use inline function to explode and expand the struct elements of col3.registrationNumbers array, then filter only rows with registrationNumberType either VAT or fiscal1 and pivot. After pivot, update the struct column col3with the pivoted columns:

In 2 steps:

1. Pivot your dataframe and convert it to a flat dict.
2. Convert tuple keys to a nested dict

Step 1

OK, that seems it's impossible to do that with connecting string. You must use a pgpass.conf file and do a file.bat like :

When updating res tables like res.company you need to start your server with the -u your_module option to perform a succesful update.

You can use @key to optimize Blazor performance, it will create a value for each element and Blazor can use this values to compare the existing items with the new ones, so Blazor can see the changes better and render the the components.