Workflow Orchestration for Precious Metals Marketing Content

Precious metals-related data is primarily sourced from the Shanghai Gold Exchange official market API and compliant third-party precious metals market

What the data for this category looks like

Precious metals-related data is primarily sourced from the Shanghai Gold Exchange official market API and compliant third-party precious metals market data providers. Real-time market data refreshes every 10 seconds. Daily settlement and total position data updates daily in the early morning. Data is formatted as structured JSON, with core fields including product code, product name, latest transaction price, price change percentage, total position, and settlement price. Units are no suffix, string, yuan/gram, percentage, kilogram, yuan/gram respectively.

What constraints these characteristics impose on workflow orchestration

The high-frequency refresh of real-time market data requires configuring reasonable call rate limits for workflows to avoid triggering data source rate limiting. The structured JSON format requires configuring dedicated field mapping rules to convert native fields returned by third-party APIs into standardized formats required for marketing content. The scheduled daily update requirement for daily data means workflows must distinguish between real-time and scheduled trigger logic, and configure corresponding scheduling rules separately. The high timeliness requirement for precious metal market data requires setting workflow node timeouts shorter than the allowable delay window for content publishing, to prevent outdated data from being used for marketing content generation.

How to set the configurations

Configuration ItemRecommended ValueRationale
HTTP_REQUEST_TIMEOUT30 secondsPrecious metal real-time market API responses typically complete within 10 seconds. An overly long timeout will cause delays in marketing content publishing
TOOL_CALL_RATE_LIMIT10 requests per minuteMost precious metal market data sources have rate limiting thresholds of 10-15 calls per minute. This value avoids triggering rate limits
SCHEDULER_CRON_EXPRESSION0 0 1 * *Adapts to scheduling requirements for daily settlement data updated at 1 AM daily
PARSE_JSON_FIELD_MAPPING{"latest_price":"price","total_hold":"position"}Maps native fields from third-party APIs to standardized fields directly usable for marketing content
DINGTALK_WEBHOOK_SEND_ASYNCtrueMarketing content push does not require synchronous waiting for a response, which avoids workflow blocking
HTTP_RESPONSE_BLOB_TYPEapplication/vnd.ms-excelExports market data as a downloadable CSV format file, adapting to user download needs

The parameter values provided on this page are common recommended starting points for configuration setup. Actual values are affected by material form, data volume and business rules. Specific issues require individual analysis. It is recommended to test on your own samples before finalizing the configuration.

Three common mistakes

  • Workflows calling precious metal market APIs return a 429 Too Many Requests status code, leaving tasks incomplete. The cause is failure to configure the TOOL_CALL_RATE_LIMIT parameter, leading to call frequency exceeding the data source's rate limiting threshold.
  • DingTalk webhook nodes fail to send marketing content, with logs showing webhook signature invalid. The cause is failure to fill in the correct DINGTALK_WEBHOOK_SECRET parameter in the configuration, resulting in signature verification failure.
  • Blob files generated by workflows cannot be downloaded in the dialog box, with no response when clicked. The cause is failure to set the HTTP_RESPONSE_BLOB_TYPE parameter to a downloadable MIME type, so browsers cannot recognize the resource as downloadable.

How to confirm configurations are correct

  • Manually trigger the workflow, view node run logs, confirm all HTTP requests return a 200 OK status code, and check that field parsing results include the required precious metal market data.
  • Configure a test DingTalk webhook address, send test marketing content, and confirm that the recipient receives a message containing real-time market data.
  • Generate a blob-format market test file, click the download button in the dialog box, and confirm that the file opens normally and contains correct data.
  • View the workflow's run monitoring panel, confirm that tool call frequency conforms to the preset rate limiting rules, with no abnormal timeout records.

Question material comes from public community discussions. Configuration values are common starting points and should be measured against your own samples. Verified on 2026-09-14.