Thanks again @okur90 for you help, I tried as you said. Here is my Create Bulk Operation GQL code with a custom date range.
mutation {
bulkOperationRunQuery(
query: """
{
orders(query: "created_at:<=2023-04-02T00:00:00Z created_at>=2023-02-30T00:00:00") {
edges {
node {
name
email
createdAt
fulfillable
displayFulfillmentStatus
displayFinancialStatus
fulfillments {
status
createdAt
displayStatus
}
id
legacyResourceId
customer {
id
}
customerAcceptsMarketing
cancelledAt
createdAt
cancelReason
confirmed
currencyCode
transactions {
id
gateway
kind
status
createdAt
}
currentSubtotalPriceSet {
presentmentMoney {
amount
currencyCode
}
shopMoney {
amount
currencyCode
}
}
currentTotalDiscountsSet {
presentmentMoney {
amount
currencyCode
}
shopMoney {
amount
currencyCode
}
}
currentTotalPriceSet {
presentmentMoney {
amount
currencyCode
}
shopMoney {
amount
currencyCode
}
}
currentTotalTaxSet {
presentmentMoney {
amount
currencyCode
}
shopMoney {
amount
currencyCode
}
}
customerLocale
discountCode
physicalLocation {
id
}
phone
paymentGatewayNames
processedAt
closed
closedAt
app {
name
icon {
id
altText
url
}
}
billingAddress {
address1
address2
city
}
lineItems {
edges {
node {
id
currentQuantity
name
product {
legacyResourceId
}
quantity
requiresShipping
title
unfulfilledQuantity
fulfillmentStatus
originalTotalSet {
presentmentMoney {
amount
currencyCode
}
shopMoney {
amount
currencyCode
}
}
totalDiscountSet {
presentmentMoney {
amount
currencyCode
}
shopMoney {
amount
currencyCode
}
}
taxLines {
priceSet {
presentmentMoney {
amount
currencyCode
}
shopMoney {
amount
currencyCode
}
}
}
}
}
}
}
}
}
}
"""
) {
bulkOperation {
id
status
}
userErrors {
field
message
}
}
}
X-Request-ID: 3875bd96-558d-4db8-90ba-fb08187acc41
But it didn't work for me, then the operation has been failed with `INTERNAL_SERVER_ERROR`. Here is the response of the current bulk operation status
{
"data": {
"currentBulkOperation": {
"id": "gid://shopify/BulkOperation/3001911771442",
"status": "FAILED",
"errorCode": "INTERNAL_SERVER_ERROR",
"createdAt": "2023-04-02T09:31:27Z",
"completedAt": null,
"objectCount": "39",
"fileSize": null,
"url": null,
"partialDataUrl": null
}
},
"extensions": {
"cost": {
"requestedQueryCost": 1,
"actualQueryCost": 1,
"throttleStatus": {
"maximumAvailable": 1000.0,
"currentlyAvailable": 999,
"restoreRate": 50.0
}
}
}
}
Could you please give me any solution? Thank you
