Hi, I wanted to get woo-commerce orders between 2 dates. I tried bef

Issue Fixed. Got the solution we need to encode the dates. <div class="snippet-cli

<a class="user-mention notranslate" data-hovercard-type="user" data-hovercard-url="/us

Not able to get orders between dates about wc-api-java HOT 3 CLOSED

calatonsystems commented on June 5, 2024

Not able to get orders between dates

from wc-api-java.

Comments (3)

xsalefter commented on June 5, 2024

I get the same problem as well. Calling the woo-commerce endpoint via CURL is fine, for example:

curl "https://www.mysite.com/wp-json/wc/v2/orders?after=2021-01-01T00:00:00.000Z&before=2021-01-20T00:00:00.000Z" -u key:secret;

Furthermore, using this parameters is working like a charm as well:

// params.put("after",  "2021-02-01T00:00:00.000Z");
        // params.put("before", "2021-02-13T00:00:00:000Z");
        params.put("context", "view");
        params.put("per_page", "20");
        params.put("page", "1");
        params.put("status", "any");
        params.put("orderby", "title");

Only when we uncomment one of before or after, then we get the exception described in this issue. Maybe there's little things that missing here.

@omandryk (sorry for mentioned you here), but do you have any idea what's going on?

from wc-api-java.

kiranuw commented on June 5, 2024

Issue Fixed. Got the solution we need to encode the dates.

String wcFormattedDate=startDate+"T00:00:00";
			Map<String, String> params = new HashMap<>();
			params.put("per_page", "10");
			params.put("after", percentEncode(wcFormattedDate));

	public String percentEncode(String s) {
		final String UTF_8 = "UTF-8";

		try {
			return URLEncoder.encode(s, UTF_8)
					// OAuth encodes some characters differently:
					.replace(SpecialSymbol.PLUS.getPlain(), SpecialSymbol.PLUS.getEncoded())
					.replace(SpecialSymbol.STAR.getPlain(), SpecialSymbol.STAR.getEncoded())
					.replace(SpecialSymbol.TILDE.getEncoded(), SpecialSymbol.TILDE.getPlain());
		} catch (UnsupportedEncodingException e) {
			throw new RuntimeException(e.getMessage(), e);
		}
	}

from wc-api-java.

xsalefter commented on June 5, 2024

@kiranuw I think this issue should not closed yet, as currently there's PR from me about this issue.

from wc-api-java.

Recommend Projects