Our requirement is to have transaction level data. We need a timestamp from transaction as well as the transaction_id.

 

 

Currently we use this deprecated endpoint (https://developer.apple.com/documentation/appstoreservernotifications/unified_receipt) to get the transaction level data out of this response object (https://developer.apple.com/documentation/appstoreservernotifications/unified_receipt/latest_receipt_info) for the following transaction columns.

• cancellation_date, cancellation_date_ms, cancellation_date_pst
• cancellation_reason
• expires_date, expires_date_ms, expires_date_pst
• is_in_intro_offer_period
• is_trial_period
• original_purchase_date, original_purchase_date_ms, original_purchase_date_pst
• is_upgraded
• purchase_date, purchase_date_ms
• transaction_id
• pending_renewal_info
• web_order_line_item_id
• original_transaction_id
• product_id
• promotional_offer_id
• quantity
• subscription_group_identifier
• transaction_id
• web_order_line_item_id
  
• first_original_transaction_id

 

I can not see that any of this data is available in your itunes_connect/apple app store connector. I have tried using `sales_subscriber_detailed` and `sales_subscription_event_summary`, but there is no timestamp or transaction_id that I can tell, it seems to only have a date. I also can't tie those reports out to `sales_summary` or `financial` within the same connector.

 

Thanks in advance