> For the complete documentation index, see [llms.txt](https://tech.x2bee.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://tech.x2bee.com/api/api-en/back-office-api-reference/statistics-bo-api/marketing-analysis.md).
# Marketing Analysis
## Retrieve Order (Sales) Status List by Inflow Channel
> \## Function Description\
> \* Retrieves the order (sales) status list by inflow channel.\
> \---\
> \## Detailed Description\
> \* Aggregates the previous day's data based on 09:00 daily.\
> \* Retrieves the order (sales) status list by inflow channel.\
> \* The aggregation type value distinguishes between order (01) and sales (02).\
> \* The inflow display category number/name is retrieved differently as follows, depending on the inflow display category number type code value.\
> \* For Display Store (01), the store category number/name\
> \* For Special Promotion (02), the special promotion number/name\
> \* For all other cases, no value\
> \---\
> \## Revision History\
> \* Release v2.00\_240827: Initial creation
```json
{"openapi":"3.1.0","info":{"title":"X2BEE BO API","version":"v1"},"servers":[{"url":"https://api-bo.x2bee.com/api/bo/","description":"prd"}],"security":[{"accessToken":[]}],"components":{"securitySchemes":{"accessToken":{"type":"http","name":"accessToken","scheme":"bearer","bearerFormat":"JWT"}},"schemas":{"PathInflowStatusRequest":{"type":"object","properties":{"siteNo":{"type":"string","description":"Site No."},"startDate":{"type":"string","format":"date","description":"Search Period (Start Date)"},"endDate":{"type":"string","format":"date","description":"Search Period (End Date)"},"agrtGb":{"type":"string","description":"Aggregation Type"},"infDispCtgNoGbCd":{"type":"string","description":"Referral Display Category No. Classification Code (OM041)"},"infDispCtgNo":{"type":"string","description":"Referral Display Category No."}}},"RealGridListResponsePathInflowStatusResponse":{"type":"object","properties":{"totalCount":{"type":"integer","format":"int32"},"payloads":{"type":"array","items":{"$ref":"#/components/schemas/PathInflowStatusResponse"}}}},"PathInflowStatusResponse":{"type":"object","properties":{"siteNo":{"type":"string","description":"Site No."},"agrtDt":{"type":"string","description":"Aggregation Date"},"agrtGb":{"type":"string","description":"Aggregation Type"},"infDispCtgNoGbCd":{"type":"string","description":"Referral Display Category No. Classification Code (OM041)"},"infDispCtgNoGbCdNm":{"type":"string","description":"Inflow Display Category No. Type Code Name"},"infDispCtgNo":{"type":"string","description":"Referral Display Category No."},"infDispCtgNm":{"type":"string","description":"Inflow Display Category Name"},"siteNm":{"type":"string","description":"Site Name"},"ordAmt":{"type":"number","description":"Order Amount"},"cnclAmt":{"type":"number","description":"Cancellation Amount"},"finalOrdAmt":{"type":"integer","format":"int64","description":"Net Order (Sales) Amount"},"ordQty":{"type":"integer","format":"int64","description":"Order (Delivery Completed) Quantity"},"cnclQty":{"type":"integer","format":"int64","description":"Cancel (Return Completed) Quantity"},"finalOrdQty":{"type":"integer","format":"int64","description":"Net Order (Sales) Quantity"},"dcAmt":{"type":"number","description":"Discount Amount (Total)"},"dcAmt2nd":{"type":"number","description":"Secondary Discount Amount"},"dcAmt3rd":{"type":"number","description":"Tertiary Discount Amount"}}},"Response":{"type":"object","properties":{"timestamp":{"type":"string","format":"date-time","description":"result time"},"code":{"type":"string","description":"result code"},"message":{"type":"string","description":"result message"},"isProcess":{"type":"boolean","description":"process check"},"payload":{"description":"payload"},"error":{"type":"boolean","description":"is error"},"errors":{"type":"array","description":"validation error list","items":{"$ref":"#/components/schemas/ValidationError"}}}},"ValidationError":{"type":"object","properties":{"field":{"type":"string","description":"field"},"message":{"type":"string","description":"field message"}}}}},"paths":{"/v1/statistics/pathInflowStatus/getPathInflowStatusList":{"get":{"tags":["Marketing Analysis"],"summary":"Retrieve Order (Sales) Status List by Inflow Channel","description":"## Function Description\n* Retrieves the order (sales) status list by inflow channel.\n---\n## Detailed Description\n* Aggregates the previous day's data based on 09:00 daily.\n* Retrieves the order (sales) status list by inflow channel.\n* The aggregation type value distinguishes between order (01) and sales (02).\n* The inflow display category number/name is retrieved differently as follows, depending on the inflow display category number type code value.\n * For Display Store (01), the store category number/name\n * For Special Promotion (02), the special promotion number/name\n * For all other cases, no value\n---\n## Revision History\n* Release v2.00_240827: Initial creation\n","operationId":"getPathInflowStatusList","parameters":[{"name":"request","in":"query","required":true,"schema":{"$ref":"#/components/schemas/PathInflowStatusRequest"}},{"name":"startDate","in":"query","description":"Search Start Date","required":true,"schema":{"type":"LocalDate"}},{"name":"endDate","in":"query","description":"Search End Date","required":true,"schema":{"type":"LocalDate"}},{"name":"infDispCtgNoGbCd","in":"query","description":"Referral Display Category No. Classification Code (OM041)","schema":{"type":"String"}},{"name":"infDispCtgNo","in":"query","description":"Referral Display Category No.","schema":{"type":"String"}},{"name":"agrtGb","in":"query","description":"Aggregation Type","required":true,"schema":{"type":"String"}}],"responses":{"200":{"description":"Success","content":{"*/*":{"schema":{"$ref":"#/components/schemas/RealGridListResponsePathInflowStatusResponse"}}}},"900":{"description":"Business processing error details","content":{"*/*":{"schema":{"$ref":"#/components/schemas/Response"}}}}}}}}}
```
## Batch Excel Download of Order (Sales) Status Grid by Inflow Channel
> \## Function Description\
> \* Generates and downloads the order (sales) status grid list by inflow channel as an Excel file.\
> \---\
> \## Detailed Description\
> \* The displayed items are the same as the grid list.\
> \* Retrieves all data matching the search conditions without paging.\
> \---\
> \## Revision History\
> \* Release v2.00\_240827: Initial creation
```json
{"openapi":"3.1.0","info":{"title":"X2BEE BO API","version":"v1"},"servers":[{"url":"https://api-bo.x2bee.com/api/bo/","description":"prd"}],"security":[{"accessToken":[]}],"components":{"securitySchemes":{"accessToken":{"type":"http","name":"accessToken","scheme":"bearer","bearerFormat":"JWT"}},"schemas":{"PathInflowStatusRequest":{"type":"object","properties":{"siteNo":{"type":"string","description":"Site No."},"startDate":{"type":"string","format":"date","description":"Search Period (Start Date)"},"endDate":{"type":"string","format":"date","description":"Search Period (End Date)"},"agrtGb":{"type":"string","description":"Aggregation Type"},"infDispCtgNoGbCd":{"type":"string","description":"Referral Display Category No. Classification Code (OM041)"},"infDispCtgNo":{"type":"string","description":"Referral Display Category No."}}},"Response":{"type":"object","properties":{"timestamp":{"type":"string","format":"date-time","description":"result time"},"code":{"type":"string","description":"result code"},"message":{"type":"string","description":"result message"},"isProcess":{"type":"boolean","description":"process check"},"payload":{"description":"payload"},"error":{"type":"boolean","description":"is error"},"errors":{"type":"array","description":"validation error list","items":{"$ref":"#/components/schemas/ValidationError"}}}},"ValidationError":{"type":"object","properties":{"field":{"type":"string","description":"field"},"message":{"type":"string","description":"field message"}}}}},"paths":{"/v1/statistics/pathInflowStatus/downloadPathInflowStatusExcel":{"get":{"tags":["Marketing Analysis"],"summary":"Batch Excel Download of Order (Sales) Status Grid by Inflow Channel","description":"## Function Description\n* Generates and downloads the order (sales) status grid list by inflow channel as an Excel file.\n---\n## Detailed Description\n* The displayed items are the same as the grid list.\n* Retrieves all data matching the search conditions without paging.\n---\n## Revision History\n* Release v2.00_240827: Initial creation\n","operationId":"downloadPathInflowStatusExcel","parameters":[{"name":"request","in":"query","required":true,"schema":{"$ref":"#/components/schemas/PathInflowStatusRequest"}},{"name":"startDate","in":"query","description":"Search Start Date","required":true,"schema":{"type":"LocalDate"}},{"name":"endDate","in":"query","description":"Search End Date","required":true,"schema":{"type":"LocalDate"}},{"name":"infDispCtgNoGbCd","in":"query","description":"Referral Display Category No. Classification Code (OM041)","schema":{"type":"String"}},{"name":"infDispCtgNo","in":"query","description":"Referral Display Category No.","schema":{"type":"String"}},{"name":"agrtGb","in":"query","description":"Aggregation Type","required":true,"schema":{"type":"String"}},{"name":"fileName","in":"query","description":"File Name","required":true,"schema":{"type":"String"}}],"responses":{"200":{"description":"Excel Download Successful"},"900":{"description":"Excel Download Failed","content":{"*/*":{"schema":{"$ref":"#/components/schemas/Response"}}}}}}}}}
```
## Retrieve Order (Sales) Status List by Member Grade
> \## Function Description\
> \* This function retrieves the order (sales) status by member grade.\
> \---\
> \## Detailed Description\
> \* Called when the search button is clicked on the Member Grade tab of the \[BO] Statistics > Marketing Analysis > Order Status by Member Attribute (Sales Status) page.\
> \* \*\*Search Period (Start Date, End Date)\*\* is a required search condition.\
> \* \*\*Site\*\* is an optional search condition.\
> \---\
> \## Revision History\
> \* Release v2.00\_240827: Initial creation of order status by member attribute
```json
{"openapi":"3.1.0","info":{"title":"X2BEE BO API","version":"v1"},"servers":[{"url":"https://api-bo.x2bee.com/api/bo/","description":"prd"}],"security":[{"accessToken":[]}],"components":{"securitySchemes":{"accessToken":{"type":"http","name":"accessToken","scheme":"bearer","bearerFormat":"JWT"}},"schemas":{"MemberOrderStatusRequest":{"type":"object","description":"Order/Sales Status by Member Attribute Request","properties":{"siteNo":{"type":"string","description":"Site No."},"entrNo":{"type":"string","description":"Vendor No."},"startDate":{"type":"string","format":"date","description":"Search Period (Start Date)"},"endDate":{"type":"string","format":"date","description":"Search Period (End Date)"},"stdCtgNo":{"type":"string","description":"Standard Category No."},"mdId":{"type":"string","description":"MD in Charge"},"brandNo":{"type":"string","description":"Brand No."},"goodsNo":{"type":"string","description":"Product No."},"agrtGb":{"type":"string","description":"Aggregation Type"},"type":{"type":"string","description":"Search Type (G: By Membership Grade, A: By Age/Gender)"}}},"RealGridListResponseMemberOrderStatusByGradeResponse":{"type":"object","properties":{"totalCount":{"type":"integer","format":"int32"},"payloads":{"type":"array","items":{"$ref":"#/components/schemas/MemberOrderStatusByGradeResponse"}}}},"MemberOrderStatusByGradeResponse":{"type":"object","description":"Order Status/Sales Status by Member Grade DTO","properties":{"siteNo":{"type":"string","description":"Site No."},"siteNm":{"type":"string","description":"Site Name"},"mbrGradeCd":{"type":"string","description":"Member Grade Code (ME003)"},"mbrGradeNm":{"type":"string","description":"Member Grade Name"},"mbrCnt":{"type":"integer","format":"int32","description":"Number of Members"},"ordAmt":{"type":"number","description":"Order Amount"},"cnclAmt":{"type":"number","description":"Cancellation Amount"},"finalOrdAmt":{"type":"integer","format":"int64","description":"Net Order Amount"},"ordQty":{"type":"integer","format":"int64","description":"Order Quantity"},"cnclQty":{"type":"integer","format":"int64","description":"Cancellation Quantity"},"finalOrdQty":{"type":"integer","format":"int64","description":"Net Order Quantity"}}},"Response":{"type":"object","properties":{"timestamp":{"type":"string","format":"date-time","description":"result time"},"code":{"type":"string","description":"result code"},"message":{"type":"string","description":"result message"},"isProcess":{"type":"boolean","description":"process check"},"payload":{"description":"payload"},"error":{"type":"boolean","description":"is error"},"errors":{"type":"array","description":"validation error list","items":{"$ref":"#/components/schemas/ValidationError"}}}},"ValidationError":{"type":"object","properties":{"field":{"type":"string","description":"field"},"message":{"type":"string","description":"field message"}}}}},"paths":{"/v1/statistics/memberOrderStatus/getMemberOrderStatusByGradeList":{"get":{"tags":["Marketing Analysis"],"summary":"Retrieve Order (Sales) Status List by Member Grade","description":"## Function Description\n* This function retrieves the order (sales) status by member grade.\n---\n## Detailed Description\n* Called when the search button is clicked on the Member Grade tab of the [BO] Statistics > Marketing Analysis > Order Status by Member Attribute (Sales Status) page.\n* **Search Period (Start Date, End Date)** is a required search condition.\n* **Site** is an optional search condition.\n---\n## Revision History\n* Release v2.00_240827: Initial creation of order status by member attribute\n","operationId":"getMemberOrderStatusByGradeList","parameters":[{"name":"memberOrderStatusRequest","in":"query","required":true,"schema":{"$ref":"#/components/schemas/MemberOrderStatusRequest"}},{"name":"startDate","in":"query","description":"Search Start Date","required":true,"schema":{"type":"LocalDate"}},{"name":"endDate","in":"query","description":"Search End Date","required":true,"schema":{"type":"LocalDate"}},{"name":"siteNo","in":"query","description":"Site No.","schema":{"type":"String"}}],"responses":{"200":{"description":"Order Status List Retrieved Successfully","content":{"*/*":{"schema":{"$ref":"#/components/schemas/RealGridListResponseMemberOrderStatusByGradeResponse"}}}},"900":{"description":"Business processing error details","content":{"*/*":{"schema":{"$ref":"#/components/schemas/Response"}}}}}}}}}
```
## Retrieve Order (Sales) Status List by Age/Gender
> \## Function Description\
> \* This function retrieves the order (sales) status by age/gender.\
> \---\
> \## Detailed Description\
> \* Called when the search button is clicked on the Age/Gender tab of the \[BO] Statistics > Marketing Analysis > Order Status by Member Attribute (Sales Status) page.\
> \* \*\*Search Period (Start Date, End Date)\*\* is a required search condition.\
> \* \*\*Site\*\* is an optional search condition.\
> \---\
> \## Revision History\
> \* Release v2.00\_240827: Initial creation of order status by member attribute
```json
{"openapi":"3.1.0","info":{"title":"X2BEE BO API","version":"v1"},"servers":[{"url":"https://api-bo.x2bee.com/api/bo/","description":"prd"}],"security":[{"accessToken":[]}],"components":{"securitySchemes":{"accessToken":{"type":"http","name":"accessToken","scheme":"bearer","bearerFormat":"JWT"}},"schemas":{"MemberOrderStatusRequest":{"type":"object","description":"Order/Sales Status by Member Attribute Request","properties":{"siteNo":{"type":"string","description":"Site No."},"entrNo":{"type":"string","description":"Vendor No."},"startDate":{"type":"string","format":"date","description":"Search Period (Start Date)"},"endDate":{"type":"string","format":"date","description":"Search Period (End Date)"},"stdCtgNo":{"type":"string","description":"Standard Category No."},"mdId":{"type":"string","description":"MD in Charge"},"brandNo":{"type":"string","description":"Brand No."},"goodsNo":{"type":"string","description":"Product No."},"agrtGb":{"type":"string","description":"Aggregation Type"},"type":{"type":"string","description":"Search Type (G: By Membership Grade, A: By Age/Gender)"}}},"RealGridListResponseMemberOrderStatusByAgeResponse":{"type":"object","properties":{"totalCount":{"type":"integer","format":"int32"},"payloads":{"type":"array","items":{"$ref":"#/components/schemas/MemberOrderStatusByAgeResponse"}}}},"MemberOrderStatusByAgeResponse":{"type":"object","description":"Order Status/Sales Status by Age/Gender DTO","properties":{"siteNo":{"type":"string","description":"Site No."},"siteNm":{"type":"string","description":"Site Name"},"ageGbCd":{"type":"string","description":"Age Type Code (ME057)"},"ageGbCdNm":{"type":"string","description":"Age Type Code Name"},"femaleOrdAmt":{"type":"integer","format":"int64","description":"Female Order Amount"},"femaleCnclAmt":{"type":"integer","format":"int64","description":"Female Cancellation Amount"},"femaleOrdQty":{"type":"integer","format":"int64","description":"Female Order Quantity"},"femaleCnclQty":{"type":"integer","format":"int64","description":"Female Cancellation Quantity"},"maleOrdAmt":{"type":"integer","format":"int64","description":"Male Order Amount"},"maleCnclAmt":{"type":"integer","format":"int64","description":"Male Cancellation Amount"},"maleOrdQty":{"type":"integer","format":"int64","description":"Male Order Quantity"},"maleCnclQty":{"type":"integer","format":"int64","description":"Male Cancellation Quantity"},"etcOrdAmt":{"type":"integer","format":"int64","description":"Unentered Order Amount"},"etcCnclAmt":{"type":"integer","format":"int64","description":"Unentered Cancellation Amount"},"etcOrdQty":{"type":"integer","format":"int64","description":"Unentered Order Quantity"},"etcCnclQty":{"type":"integer","format":"int64","description":"Unentered Cancellation Quantity"},"totalOrdAmt":{"type":"integer","format":"int64","description":"Total Order Amount"}}},"Response":{"type":"object","properties":{"timestamp":{"type":"string","format":"date-time","description":"result time"},"code":{"type":"string","description":"result code"},"message":{"type":"string","description":"result message"},"isProcess":{"type":"boolean","description":"process check"},"payload":{"description":"payload"},"error":{"type":"boolean","description":"is error"},"errors":{"type":"array","description":"validation error list","items":{"$ref":"#/components/schemas/ValidationError"}}}},"ValidationError":{"type":"object","properties":{"field":{"type":"string","description":"field"},"message":{"type":"string","description":"field message"}}}}},"paths":{"/v1/statistics/memberOrderStatus/getMemberOrderStatusByAgeList":{"get":{"tags":["Marketing Analysis"],"summary":"Retrieve Order (Sales) Status List by Age/Gender","description":" ## Function Description\n * This function retrieves the order (sales) status by age/gender.\n ---\n ## Detailed Description\n * Called when the search button is clicked on the Age/Gender tab of the [BO] Statistics > Marketing Analysis > Order Status by Member Attribute (Sales Status) page.\n * **Search Period (Start Date, End Date)** is a required search condition.\n * **Site** is an optional search condition.\n ---\n ## Revision History\n * Release v2.00_240827: Initial creation of order status by member attribute\n","operationId":"getMemberOrderStatusByAgeList","parameters":[{"name":"memberOrderStatusRequest","in":"query","required":true,"schema":{"$ref":"#/components/schemas/MemberOrderStatusRequest"}},{"name":"startDate","in":"query","description":"Search Start Date","required":true,"schema":{"type":"LocalDate"}},{"name":"endDate","in":"query","description":"Search End Date","required":true,"schema":{"type":"LocalDate"}},{"name":"siteNo","in":"query","description":"Site No.","schema":{"type":"String"}}],"responses":{"200":{"description":"Success","content":{"*/*":{"schema":{"$ref":"#/components/schemas/RealGridListResponseMemberOrderStatusByAgeResponse"}}}},"900":{"description":"Business processing error details","content":{"*/*":{"schema":{"$ref":"#/components/schemas/Response"}}}}}}}}}
```
## Download Order (Sales) Status List by Member Grade as Excel
> \## Function Description\
> \* Downloads the order (sales) status list by member grade as an Excel file.\
> \---\
> \## Detailed Description\
> \* Downloads the order (sales) status list by member grade as an Excel file with unpaged data.\
> \* If the requested aggregation type code is '01', order status information is provided.\
> \* If the requested aggregation type code is '02', sales status information is provided.\
> \---\
> \## Revision History\
> \* Release v2.00\_240827: Initial creation of order status by member attribute
```json
{"openapi":"3.1.0","info":{"title":"X2BEE BO API","version":"v1"},"servers":[{"url":"https://api-bo.x2bee.com/api/bo/","description":"prd"}],"security":[{"accessToken":[]}],"components":{"securitySchemes":{"accessToken":{"type":"http","name":"accessToken","scheme":"bearer","bearerFormat":"JWT"}},"schemas":{"MemberOrderStatusRequest":{"type":"object","description":"Order/Sales Status by Member Attribute Request","properties":{"siteNo":{"type":"string","description":"Site No."},"entrNo":{"type":"string","description":"Vendor No."},"startDate":{"type":"string","format":"date","description":"Search Period (Start Date)"},"endDate":{"type":"string","format":"date","description":"Search Period (End Date)"},"stdCtgNo":{"type":"string","description":"Standard Category No."},"mdId":{"type":"string","description":"MD in Charge"},"brandNo":{"type":"string","description":"Brand No."},"goodsNo":{"type":"string","description":"Product No."},"agrtGb":{"type":"string","description":"Aggregation Type"},"type":{"type":"string","description":"Search Type (G: By Membership Grade, A: By Age/Gender)"}}},"Response":{"type":"object","properties":{"timestamp":{"type":"string","format":"date-time","description":"result time"},"code":{"type":"string","description":"result code"},"message":{"type":"string","description":"result message"},"isProcess":{"type":"boolean","description":"process check"},"payload":{"description":"payload"},"error":{"type":"boolean","description":"is error"},"errors":{"type":"array","description":"validation error list","items":{"$ref":"#/components/schemas/ValidationError"}}}},"ValidationError":{"type":"object","properties":{"field":{"type":"string","description":"field"},"message":{"type":"string","description":"field message"}}}}},"paths":{"/v1/statistics/memberOrderStatus/downloadMemberOrderStatusByGradeExcel":{"get":{"tags":["Marketing Analysis"],"summary":"Download Order (Sales) Status List by Member Grade as Excel","description":" ## Function Description\n * Downloads the order (sales) status list by member grade as an Excel file.\n ---\n ## Detailed Description\n * Downloads the order (sales) status list by member grade as an Excel file with unpaged data.\n * If the requested aggregation type code is '01', order status information is provided.\n * If the requested aggregation type code is '02', sales status information is provided.\n ---\n ## Revision History\n * Release v2.00_240827: Initial creation of order status by member attribute\n","operationId":"downloadMemberOrderStatusByGradeExcel","parameters":[{"name":"memberOrderStatusRequest","in":"query","required":true,"schema":{"$ref":"#/components/schemas/MemberOrderStatusRequest"}},{"name":"type","in":"query","description":"Search Type (G: By Membership Grade, A: By Age/Gender)","required":true,"schema":{"type":"String"}},{"name":"agrtGb","in":"query","description":"Aggregation Type","required":true,"schema":{"type":"String"}},{"name":"startDate","in":"query","description":"Search Start Date","required":true,"schema":{"type":"LocalDate"}},{"name":"endDate","in":"query","description":"Search End Date","required":true,"schema":{"type":"LocalDate"}},{"name":"siteNo","in":"query","description":"Site No.","schema":{"type":"String"}}],"responses":{"200":{"description":"Success"},"900":{"description":"Business processing error details","content":{"*/*":{"schema":{"$ref":"#/components/schemas/Response"}}}}}}}}}
```
## Download Order (Sales) Status List by Age/Gender as Excel
> \## Function Description\
> \* Downloads the order (sales) status list by age/gender as an Excel file.\
> \---\
> \## Detailed Description\
> \* Downloads the order (sales) status list by age/gender as an Excel file with unpaged data.\
> \* If the requested aggregation type code is '01', order status information is provided.\
> \* If the requested aggregation type code is '02', sales status information is provided.\
> \---\
> \## Revision History\
> \* Release v2.00\_240827: Initial creation of order status by member attribute
```json
{"openapi":"3.1.0","info":{"title":"X2BEE BO API","version":"v1"},"servers":[{"url":"https://api-bo.x2bee.com/api/bo/","description":"prd"}],"security":[{"accessToken":[]}],"components":{"securitySchemes":{"accessToken":{"type":"http","name":"accessToken","scheme":"bearer","bearerFormat":"JWT"}},"schemas":{"MemberOrderStatusRequest":{"type":"object","description":"Order/Sales Status by Member Attribute Request","properties":{"siteNo":{"type":"string","description":"Site No."},"entrNo":{"type":"string","description":"Vendor No."},"startDate":{"type":"string","format":"date","description":"Search Period (Start Date)"},"endDate":{"type":"string","format":"date","description":"Search Period (End Date)"},"stdCtgNo":{"type":"string","description":"Standard Category No."},"mdId":{"type":"string","description":"MD in Charge"},"brandNo":{"type":"string","description":"Brand No."},"goodsNo":{"type":"string","description":"Product No."},"agrtGb":{"type":"string","description":"Aggregation Type"},"type":{"type":"string","description":"Search Type (G: By Membership Grade, A: By Age/Gender)"}}},"Response":{"type":"object","properties":{"timestamp":{"type":"string","format":"date-time","description":"result time"},"code":{"type":"string","description":"result code"},"message":{"type":"string","description":"result message"},"isProcess":{"type":"boolean","description":"process check"},"payload":{"description":"payload"},"error":{"type":"boolean","description":"is error"},"errors":{"type":"array","description":"validation error list","items":{"$ref":"#/components/schemas/ValidationError"}}}},"ValidationError":{"type":"object","properties":{"field":{"type":"string","description":"field"},"message":{"type":"string","description":"field message"}}}}},"paths":{"/v1/statistics/memberOrderStatus/downloadMemberOrderStatusByAgeExcel":{"get":{"tags":["Marketing Analysis"],"summary":"Download Order (Sales) Status List by Age/Gender as Excel","description":" ## Function Description\n * Downloads the order (sales) status list by age/gender as an Excel file.\n ---\n ## Detailed Description\n * Downloads the order (sales) status list by age/gender as an Excel file with unpaged data.\n * If the requested aggregation type code is '01', order status information is provided.\n * If the requested aggregation type code is '02', sales status information is provided.\n ---\n ## Revision History\n * Release v2.00_240827: Initial creation of order status by member attribute\n","operationId":"downloadMemberOrderStatusByAgeExcel","parameters":[{"name":"memberOrderStatusRequest","in":"query","required":true,"schema":{"$ref":"#/components/schemas/MemberOrderStatusRequest"}},{"name":"type","in":"query","description":"Search Type (G: By Membership Grade, A: By Age/Gender)","required":true,"schema":{"type":"String"}},{"name":"agrtGb","in":"query","description":"Aggregation Type","required":true,"schema":{"type":"String"}},{"name":"startDate","in":"query","description":"Search Start Date","required":true,"schema":{"type":"LocalDate"}},{"name":"endDate","in":"query","description":"Search End Date","required":true,"schema":{"type":"LocalDate"}},{"name":"siteNo","in":"query","description":"Site No.","schema":{"type":"String"}}],"responses":{"200":{"description":"Success"},"900":{"description":"Business processing error details","content":{"*/*":{"schema":{"$ref":"#/components/schemas/Response"}}}}}}}}}
```