# Oracle Fusion REST API: customers, projects and manufacturing work orders > Source: https://netray.co/erp-help/oracle-fusion-rest-api-customers-projects-work-orders-examples > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: ERP Help ## Short answer Oracle Fusion Cloud Applications exposes REST resources under a base path per product family, for example /fscmRestApi/resources// for supply chain, financials and projects and /crmRestApi/resources// for customer data in sales. Authenticate with basic authentication or OAuth, then use q, fields, limit, offset, expand and onlyData to shape results. Resource names differ by product, so confirm them in the REST API documentation for your release. ## Kind how-to ## System oracle-fusion ## Erp Oracle Fusion Cloud Applications ## Module REST APIs / Integration ## Query oracle fusion rest api ## Alternate Queries - oracle fusion customer api - oracle fusion projects api - oracle fusion manufacturing rest api - oracle fusion cloud applications api ## Applies To Oracle Fusion Cloud Applications (ERP, SCM, Manufacturing, Project Management, CX). REST version segments such as 11.13.18.05 follow your release, and available resources depend on licensed offerings. ## Steps ### How to call a Fusion REST API **Items:** - Find your pod host name, for example https://.fa..oraclecloud.com, and the REST API reference on Oracle Help Center for your release. - Create an integration user with the roles needed to view or maintain the target data, and avoid using a named employee account. - Pick the resource, such as customers or accounts, projects or work orders, and read its attributes, child resources and finders in the reference. - Send a GET to the collection URL with Basic authentication (or an OAuth bearer token) and the header Content-Type: application/json. - Filter with q, for example q=WorkOrderNumber='WO1001', and trim the payload with fields and onlyData=true. - Page with limit and offset and use totalResults=true when you need a count. Follow the next link in the links array. - Use expand to pull child resources in one call instead of looping through each parent. - For writes, POST or PATCH a JSON body and handle 4xx validation messages. Use ESS jobs or FBDI for large volumes. ## Sections ### Where the resources live **Body:** Fusion REST is organised by product family. Supply chain, manufacturing, procurement, financials and project resources sit under the fscmRestApi path. Sales and customer relationship resources sit under crmRestApi, and human resources under hcmRestApi. Customer data can appear in more than one place depending on whether you mean a trading partner account in Receivables or an account in Sales. Decide which you need before choosing the endpoint. **Code:** - GET https://.fa..oraclecloud.com/fscmRestApi/resources/11.13.18.05/workOrders?q=WorkOrderNumber='WO1001'&onlyData=true&limit=25 ### Projects and manufacturing examples **Body:** For projects, the project resource exposes project definitions, tasks and related child collections, and expand lets you retrieve tasks along with the project. For manufacturing, the work order resource returns headers with operations, materials and resources as child collections. Read the describe metadata at the resource URL with /describe to see the exact attributes, finders and supported actions instead of guessing. ### Authentication and security **Body:** Basic authentication is simple for scripts but ties the integration to a password that expires. OAuth with JWT or an identity provider token is better for production. Whichever you choose, grant the smallest role set that works. Use the REST-Framework-Version header when you need to pin framework behaviour, and test after each quarterly update because behaviour and resources evolve. ### Volume and alternatives **Body:** REST suits transactional lookups and small writes. For loading thousands of rows, use File-Based Data Import and the related ESS jobs. For analytics, use BI Publisher or OTBI extracts instead of pulling everything through paging. Avoid chatty patterns that call one request per child record. Use expand and fields to reduce round trips. ## Pitfalls - Using an employee account for integration and breaking it on password expiry. - Guessing resource names instead of checking the REST reference and the describe endpoint. - Requesting full payloads with no fields or limit. - Not retesting integrations after quarterly updates. - Using REST for bulk loads that belong in FBDI. ## Ai Angle A grounded assistant uses these same REST resources as read-only tools: it picks the resource, builds the q filter, expands the child collection and shows the exact URL it called, so users can check the source of every answer. For organisations with data residency or air-gap concerns, the language model can be hosted privately while it calls the Fusion APIs under a least-privilege integration user, and any create or update is held for human approval. ## Faq ### What is the Oracle Fusion REST API base URL? **Answer:** It follows your pod host with a product path, for example https://.fa..oraclecloud.com/fscmRestApi/resources//. The version segment depends on your release. ### How do I filter and page results? **Answer:** Use q for filters, fields to select attributes, limit and offset for paging, and totalResults=true for a count. Follow the next link in the response for the following page. ### Can I get work orders from Fusion Manufacturing by REST? **Answer:** Yes, manufacturing exposes work order resources with operation, material and resource child collections. Confirm the exact resource names and permissions in the reference for your release. ### When should I use FBDI instead of REST? **Answer:** Use File-Based Data Import for bulk loads and migrations because it processes many rows through ESS jobs. Use REST for interactive lookups and small updates. ## Search terms oracle fusion rest api, oracle fusion customer api, oracle fusion projects api, oracle fusion manufacturing rest api, oracle fusion cloud applications api, fscmRestApi, oracle fusion work orders rest, fusion rest api expand --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json