Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

Loading shopify data to bigquery

I want to load orders data from shopify to bigquery. Below is my application integration

1. Fetch Shopify Data is able to gather the orders data

2. Data Mapping: I am converting json into array.

3. For each loop calls the sub integration

prateekcholkar_0-1739798874524.png

Sub Integration:

1. Issue / Error: Sub Integration fails with below error

{
"message": "Required parameter Connector input payload is not present.",
"code": 500
}

prateekcholkar_1-1739799100302.png

prateekcholkar_0-1739800812649.png

Order Data from the parent integration service

prateekcholkar_1-1739800920545.png

Error message on parent integration:

'Required parameter Connector input payload is not present.' eventMessages without params: '[name: "CreateOrderSubIntegration" event_info_id: "9d2dfd6f-03e4-4fb4-bcbd-3500ff37a9f8" trigger_id: "api_trigger/CreateOrderSubIntegration_API_1" client_id: "79307376312" execution_state: FAILED cloud_logging_details { } event_bus_status: ACTIVE snapshot_number: 3 workflow_origin: UI ]' error/code: 'common_error_code: INVALID_PARAMETER'

 

 

 

 

 

 

0 2 149
2 REPLIES 2

Thank you for asking this question. Have you mapped the variables("Map to additional sub-integration input") from the parent integration(the one which contains For-Loop) to the child integration(containing BQ connection) in your For-Each Loop task ?  Screenshot 2025-02-18 at 6.11.01 PM.png

Hello @vsy 

Below is the setup, I have. Do you think I am missing something here. Please confirm 

`Task_1_connectorInputPayload` - It is the input for subintegration

prateekcholkar_0-1739991679492.png

prateekcholkar_1-1739992033318.png

 

Top Labels in this Space