Amazing stuff Bro... I had a question if you could help it would be great... I need to expose a "custom sql joined query CCT data" as a REST API to other website in which there will be a "auth_code" query parameter (which will use used with CUSTOM AUTH table join). Any leads on how I can do this? Thanks in advance.
CCT has REST API endpoints which you can use to access CCT data from outside without join SQL. If you need filteration it does provide that. For auth you can use wordpress user application password.
@@MoxetKhanPK yes thats true CCT has its a REST API, but I plan to make a "custom sql joined data query" which will join 3 CCT.. similar to a stored procedure data output.. one table which will be joined will be a cct_AUTH table which will return data only if the @auth_code_param query variable param matches... Have you encountered such use cases?
@@MoxetKhanPK Currently in Jetengine there is only REST API url for one CCT table is possible.. Hope I am able to explain it correctly but I am trying to convert this custom query output as a REST API url with auth_code query parameter as its basis for custom authentication. this will take the use case of REST API to the next level and may also eliminate the application passwords use. Any idea or video if could make will be of great help. Thanks. Have a nice day. Cheers
Thank you! This is a great tutorial! I want to display woocommerce orders based on user input. Example: user inputs order id plus email and it shows order details. What do you suggest? In the video, you show us you can't filter, but can't we just filter in another way? Thank you again!
Thanks for the awesome tutorial. This is really informative. One question, if we want to paginate in REST API, how we can do it (like sending page number and limit)? Like in the example, you call 100 records at once and then use datatable to split data into 10 records per page. But can we pass something in REST API so that, REST API can understand how much data to send as a response and we can show it through Jet Dynamic table with pagination support? I couldn't find anything regarding pagination with REST API when we use Jet Engine tabe (with query builder).
Hello! Great video, thank you for the explanation. Can we use the JetEngine to programmatically create a product in WooCommerce from another website (with the PUT)? Thanks
how to make cct single page without using REST API ? it is possible ? i try to make single page with cct and use feature "has a single page". but it's limited, and I only can add post title and content. i need to show dynamic table in every single page
@@MoxetKhanPK Thanks, for your reply Moxet. A tutorial with Shopify would be nice because Shopify is so much faster than Woocommerce but it´s pain in the ass to customize. A combination of Wordpress und Shopify sounds perfect.
@@karl-knoop The integration you intend to build is not recommended, only for design you have to bring your data from shopify to wp? there are 100 of back & forth functions which you need to apply. My guess was to display the data & reports in your wp from Shopify which might bring some benifits.
Thanks Khan. I'm used this tutorial to display Woocommerce orders, but I would like to show in my listing just orders for the logged in user. As I can see the filter inside the Query builder is not working right? Can you suggest me another solution to do it?
@@MoxetKhanPK I am working with WordPress. And in WordPress its url in localhost is http, but API is actually sending in https. Therefore it generates an error. How can I overcome such issue?
![[Part 03] Ticketing System | Create Agents | Add User from Front-end in JetEngine](http://i.ytimg.com/vi/73hxY2GkwGA/mqdefault.jpg)
![[Part 03] Ticketing System | Create Agents | Add User from Front-end in JetEngine](/img/tr.png)
Amazing stuff Bro...
I had a question if you could help it would be great...
I need to expose a "custom sql joined query CCT data" as a REST API to other website in which there will be a "auth_code" query parameter (which will use used with CUSTOM AUTH table join).
Any leads on how I can do this?
Thanks in advance.
CCT has REST API endpoints which you can use to access CCT data from outside without join SQL. If you need filteration it does provide that. For auth you can use wordpress user application password.
@@MoxetKhanPK yes thats true CCT has its a REST API, but I plan to make a "custom sql joined data query" which will join 3 CCT.. similar to a stored procedure data output.. one table which will be joined will be a cct_AUTH table which will return data only if the @auth_code_param query variable param matches...
Have you encountered such use cases?
@@MoxetKhanPK Ex. SELECT FROM tabl1, table2, authtable where tabl1.col1 = tabl2.col2 and authtable.codecolulm = auth_code_queryparamater
@@rookiesmarts you want to make a listing over these queries? It yes it is possible.
@@MoxetKhanPK Currently in Jetengine there is only REST API url for one CCT table is possible..
Hope I am able to explain it correctly but I am trying to convert this custom query output as a REST API url with auth_code query parameter as its basis for custom authentication.
this will take the use case of REST API to the next level and may also eliminate the application passwords use.
Any idea or video if could make will be of great help.
Thanks. Have a nice day. Cheers
Thank you! This is a great tutorial! I want to display woocommerce orders based on user input. Example: user inputs order id plus email and it shows order details. What do you suggest? In the video, you show us you can't filter, but can't we just filter in another way? Thank you again!
There are two ways, either store the data from API to your site or use datatable to display data and apply JqueryDataTable for filteration.
Amazing Abdul Moxet, keep going bro,
Thanks for the awesome tutorial. This is really informative. One question, if we want to paginate in REST API, how we can do it (like sending page number and limit)? Like in the example, you call 100 records at once and then use datatable to split data into 10 records per page. But can we pass something in REST API so that, REST API can understand how much data to send as a response and we can show it through Jet Dynamic table with pagination support? I couldn't find anything regarding pagination with REST API when we use Jet Engine tabe (with query builder).
You are great bro. more videos about rest api and woocommerce. Thanke you🙏
Thank you so much for this tutorial, wanna just ask if we can add an image from a url to the table? Thank you
Yes you can show it through images,
"images": [
{
"id": 795,
"date_created": "2017-03-23T14:03:08",
"date_created_gmt": "2017-03-23T20:03:08",
"date_modified": "2017-03-23T14:03:08",
"date_modified_gmt": "2017-03-23T20:03:08",
"src": "example.com/wp-content/uploads/2017/03/T_4_front-11.jpg",
"name": "",
"alt": ""
},
Hello! Great video, thank you for the explanation. Can we use the JetEngine to programmatically create a product in WooCommerce from another website (with the PUT)? Thanks
Thanks for the tutorial MK. I don't know. But i'm learning this stuff. Can I use this idea possibly for posts and not products?
REST API works with CPT and Products both, you can try on anything.
It should be ---> ?consumer_key=xxx&consumer_secret=xxx and not ?consumer_key=xxx&secret_key=xxx. For people who are facing the 400 errors.
Thanks for the great tut Guru!
Thanks for the great Tutorial. Can We Filter these records using jetsmartfilters?
No filteration as of now
@@MoxetKhanPK Thankyou
Magic! Thank you
how to make cct single page without using REST API ? it is possible ?
i try to make single page with cct and use feature "has a single page". but it's limited, and I only can add post title and content. i need to show dynamic table in every single page
Great tutorial! Is it also possible to integrate products into wordpress via the Shopify REST API?
Yes why not!
@@MoxetKhanPK Thanks, for your reply Moxet. A tutorial with Shopify would be nice because Shopify is so much faster than Woocommerce but it´s pain in the ass to customize. A combination of Wordpress und Shopify sounds perfect.
@@karl-knoop The integration you intend to build is not recommended, only for design you have to bring your data from shopify to wp? there are 100 of back & forth functions which you need to apply. My guess was to display the data & reports in your wp from Shopify which might bring some benifits.
Thanks Khan. I'm used this tutorial to display Woocommerce orders, but I would like to show in my listing just orders for the logged in user. As I can see the filter inside the Query builder is not working right? Can you suggest me another solution to do it?
Yes filteration is not working as of now, we need to wait untill is fixed.
Hello! Did you manage to do this filtering?
With the read/write access, how would you "write" (I assume it means to update) the information?
You need to use Jetform builder with POST action to target certain endpoints & send exactly the same information they require.
Can I use API on my localhost? I am working with xampp.
Yes you can use, you must have internet
@@MoxetKhanPK I am working with WordPress. And in WordPress its url in localhost is http, but API is actually sending in https. Therefore it generates an error. How can I overcome such issue?
If you want to show images from the REST API request of woocommerce, please follow these settings.
imgur.com/a/as1DqHn
Hi , May you tell me how to setting the API image clickable and link to Product ?