Converting numbers to strings in Airbyte parent stream flow

Slack Knowledge Base Q&A Connector Development
, , , ,
1

Summary

When creating a parent stream flow in Airbyte, the numbers are being converted to strings. How can I transform these numbers back into strings?


Question

Good morning everyone, I´m brand new airbyte user and I´m trying to create a parent stream flow such as https://app.vindi.com.br/api/v1/periods/*{{ stream_partition.periodo}}/*usages, the parent stream is working fine and it´s returning as parameters for the child stream but it´s converting to numbers, example: https://app.vindi.com.br/api/v1/periods/*86307912.0*/usages?page=1&per_page=50 how can i transform such numbers into strings 86307912.0 -> 86307912 ?


This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.

Join the conversation on Slack

["airbyte", "parent-stream-flow", "numbers", "strings", "conversion"]
2

One ] after 8 and it should work
Just make sure for every partition you need first 8 character

3

It´s not working:
https://app.vindi.com.br/api/v1/periods/{{stream_partition.periodo[:8]}}/usages

turns into:
<https://app.vindi.com.br/api/v1/periods/%7B%7Bstream_partition.periodo%5B:8%5D%7D%7D/usages?page=1&amp;per_page=50>

4

Not sure then
This might help

https://stackoverflow.com/questions/45926231/cannot-round-float-to-integer-using-jinja2|https://stackoverflow.com/questions/45926231/cannot-round-float-to-integer-using-jinja2

No need to multiply by 100
Or you can use round filter

5

thank you Aviraj, I´ll dive deeper in jinja documentation, I´ll let you know if there´s a solution

6

solved!
{{( stream_partition.periodo)|int}}
did the trick, thank you again

7

Yes you can consider stream_partition.periodo as a python string
You can use stream_partition.periodo[:8]

8

URL Path: https://app.vindi.com.br/api/v1/periods/{{stream_partition.periodo[:8}}/usages ?