Need a little bit of help, i’m new to uipath studio.
I am looking to import a PDF invoice into Xero from a client, xero has a built in functionality that if you follow a certain excel format (attached) CSV it will upload it to its software for you.
The scenario is there are multiple lines for the invoice which is in a PDF format, right now i am using get OCR text to get data from the PDF, then write cell in a get application scope to put it in the right Xero CSV template file. This is fine if the amount of lines are always the same which it wont be.
My question is how can i make the bot/uipath pick up all the lines so that it detects it correctly, if there is 1 or 10 as my current workflow relies on there only being 3.