Lexoffice and Voucher Numbers

How To
1

Hi,

I am trying to read a cell in Google Sheets which contains a Lexoffice Voucher Number, then use the Search Vouchers Module with this string and add the payment status to the same sheet.

What is working:

  • Reading the cell in sheets with the voucher number and passing it to the Lexoffice Search Vouchers Module
  • Update a cell in the same sheet

What isn’t working:
the search vouchers module can’t find any voucher numbers based on the value of the cell (even if I hard code an existing voucher number in the module, it can’t find it)

Based on the Lexoffice API voucher numbers need to be strings, which sheets gives me.

Any ideas?

2

Howdy @OHA_Daniel Welcome to the community!

I would love to help you troubleshoot this :smiley: But first: Can you quickly share a couple of screenshots with me of your scenario module configure sections.

:warning: Remember to Redact Sensitive and Personally Identifiable Data

(click here to learn why this is important)

:information_source: This is to protect you, your customers, clients, family, make account, and 3rd party integration account connection information from malicious actors on the internet.

:warning: NO ONE in the community will ask for your :make: make organization login, or any other account login information. If they do, please notify an admin as it is against our TOS.

It is likely a particular quirk in data structure for either google or lexoffice,

2 Likes
3

Hi,

thanks for looking into it. So, to start this is what the Lexoffice API gives out as voucher numbers
VoucherType

This is the Make setup:

MakeModules
MakeModules1369×494 49.5 KB

And the individual parts:

MakeGetACell
MakeGetACell767×700 56.8 KB

MakeSearchVouchers
MakeSearchVouchers809×639 40.6 KB

MakeUpdateCell
MakeUpdateCell845×765 81.6 KB

Let me know if you need more info.

4

Have not forgotten your query :slight_smile:

https://developers.lexoffice.io/docs/#vouchers-endpoint-voucher-properties

reviewing the vouchers endpoint documentation.
will circle back this weekend.

1 Like
5

Did you find anything, or was it user error after all? :smile:

6

@JugaadiTech sorry to bother you again with this, but do you think there will be a solution soon? I will put my project on the backburner for a bit if it’s not the case, np.

7

hello? What happened to “I will circle back this weekend”?

8

Sorry Man,
Got slammed last week by the day job.
ended up working some 100 hours over the last 8 days, havent had a lot of breathing room

(also not being a native german speaker :rofl:) its taking me a bit to parse through some of it.

But i still have a recurring reminder to get a solution for ya :smiley:

2 Likes
9

All good, thanks for the update. Let me know if I can help with translation or something

10

You can close this if you want. I coded a solution in Google Apps Script directly by calling the Lexoffice API.

1 Like