Here is a stronger version suitable for a Fivetran feature request:

Connector name:
ShipHero

Table name:
orders

Column to add:
shipping_lines.price

API documentation link:
Order - GraphQL API

Additional details:

We would like to request that the shipping_lines.price field from the ShipHero GraphQL Order API be exposed/synced to the orders table.

We have verified through the ShipHero GraphQL API that shipping_lines is available under an order and returns the shipping details, including:

shipping_lines {
  title
  carrier
  method
  price
}

However, this information is currently not available in the Fivetran-synced orders table.

Why this field is important:

1. Accurate financial reporting – The shipping amount is an important component of the total amount associated with an order and is required for accurate financial reporting.

2. Order reconciliation – It allows us to reconcile order-level totals between ShipHero, source reports, and our downstream BigQuery data.

3. Shipping revenue analysis – We can separately identify product revenue and shipping charges instead of treating the entire order amount as product revenue.

4. Data validation – Having the API-provided shipping price allows us to validate whether the order totals and shipping charges in our downstream reports are accurate.

5. Avoid indirect calculations – Without this field, we would need to derive the shipping amount from shipment/label-level data, which may not represent the actual shipping charge applied to the customer.

Since the field is already available through the ShipHero GraphQL API, we would appreciate it if Fivetran could expose/sync this field in the orders table.