Lexoffice and Voucher Numbers

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?

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

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:

And the individual parts:


Let me know if you need more info.

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

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

@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.

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

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

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