Summary
Custom connector for API data extraction is facing issues with User Input values, specifically with automating the ‘Date’ parameter to extract only the previous day’s data.
Question
hello all - i’m working on a custom connector, to extract data out of an API
the API looks like this:
/services/api/Recruiting/JobApplicant?CurrentStatus={Status}&StatusDate={Date}
this works perfectly fine when i’m using Parameterized Requests for the Status and Date - where I hardcode a list of Parameter Values via a Value List
however - i’d like to automate the Date to extract only the previous day’s data. for this i’ve used the User Input and a code value of {{ day_delta(1) }}
this runs, however, the request resolves to:
where the StatusDate is truncated to 2 (not the full date)
i’m using airbyte cloud - so wondering if anyone has also come up against problems with User Input values?
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.