fivetran / fivetran/dbt_shopify

[Feature] Obtain the Exchange Rate field from somewhere else other than the `receipt` field in Transactions

Open
#71 0 comments 0 reactions 0 assignees View on GitHub
enhancement
Dominant language
No language data
Stars
82
Forks
47
Avg merge
5d 4h
Merged PRs (30d)
4

Description

### Is there an existing feature request for this?

- [X] I have searched the existing issues

### Describe the Feature

Currently, the package obtains the `exchange_rate` field from the Transactions object in a JSON field titled `receipt`. This works to obtain the exchange rate provided within the receipt. However, the receipt for different payment processors is not always the same and also may not be entirely accurate (especially when considering returns).

This FR is to leverage some other method of obtaining the `exchange_rate` field to be used within the downstream transformation logic in this package.

### Describe alternatives you've considered

At the moment we will continue to leverage the `receipt` field in the Transactions table.

Unfortunately, we are unaware if there is another solution. But this FR is intended for the team and community to ideally find an alternative for the package to leverage.

### Are you interested in contributing this feature?

- [ ] Yes.
- [ ] Yes, but I will need assistance and will schedule time during your [office hours](https://calendly.com/fivetran-solutions-team/fivetran-solutions-team-office-hours) for guidance.
- [ ] No.

### Anything else?

_No response_

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.