Find related orders in Shopify and BillBee

Questions
, , ,
1

Hi all,

i try to create my first scenario for this topic:

I use Shopify, DHL and BillBee and i want to create an automation for sending bill and reminder to the end customers via BillBee. For this i want to set a Tag “Zugestellt” at the BillBee Order once the parcel has been delivered.

  • Webhook to get all the orders from shopify - working
  • Filter for orders which have already a DHL trackingnumber - working
  • HTTP request for the DHL API to get the tracking status - working
  • Filter for orders with tracking status delivered - working

And now i need to GET the related order from BillBee to POST the Tag

In Shopify the ID is for example: name: #2230.1

The Output from BillBee is: OrderNumber":"#2230

Until now i was not able to create the relationship. I tried it for example with https://app.billbee.io/api/v1/orders/findbyextref/%23{{replace(replace(1.name; “#”; “”); “.1”; “”)}}

But it is not working:
DataError

Error: 404 Not Found

  • {“ErrorMessage”:“The order # does not exist”,“ErrorCode”:2,“ErrorDescription”:“OrderNotFound”,“Data”:null}

Any idea or maybe there is a much simpler way to set a Tag in BillBee once DHL has been delivered.

KR
Ralf

3

Hey there,

did you try your formula first inside a set a variable module to see if its returning the correct output?

4

I tried it:

This is the Output from the Webhook:

image
image347×111 9.39 KB

This my Tool:

image
image645×456 30.2 KB

But the Output did not change and is still #xxxx.1:

image
image503×600 31.9 KB

5

Try using {{emptystring}} instead of leaving it empty. Also if its fixed length and # is always at the start and then you need the next 4 numbers you can try with

{{substring(#2230.1; 1; 5)}}