Authentication Process Perform a GET on https://{SERVERNAME}/v1/rest/auth In the response look in the HTTP header for the Auth-Nonce Generate an Auth-Nonce-Response using the following calculation: Perform a GET on https://{SERVERNAME}/v1/rest/auth?usr={USER}&pwd={PASSWORD} with both the Auth-Nonce and the Auth-Nonce-Response values in the header. Replace the {USER} and {PASSWORD} with actual values. Read the Auth-Session value from the response. This is your session token and is used to identify your connection. It must be present in the header of all calls made for your session. Perform a GET on https://{SERVERNAME}/v1/rest/sit?ws={WORKSTATIONNAME} to claim a seat. (Don't forget to add the Token to the request header from step 4.) Main API to get Sales data: http://server/v1/rest/document?page_size=6&page_no=1&cols=*,item.*,tender.*&filter=(invoice_posted_date,ge,2021-10-24T00:00:00.000+00:00) Where we need to send last run date-time and get all pages This is how to configure in AllSync to automatic download sales data from PRISM: Create new application PRISM Create new sales table with fields we want to store data Create an integration flow Create a data mapper AllSync introduces new feature for authentication list of API to be called. Authorization: Get Document:   Params:filter = (invoice_posted_date,ge,{{applicationConfigurations.as_salesOrder_lastRun | minus:28800 | date: '%Y-%m-%d %H:%M:%S'}}) page_no=<{i}> page_size=3

AllSync.IO has introduced a new feature to manage the lifespan of data. As a middleware system, AllSync may need to automatically delete data after a certain period for various reasons, including security, data cleanliness, cost savings, and performance optimization.   This feature includes an option in the Application Settings, allowing users to configure how long queue data or archived queue data is retained. Once the specified time expires, the older data is automatically deleted.   A similar setting is available for User-Defined Tables, enabling users to define how long the main data in a table should be retained before being automatically removed.

  Configure Permalink Enable API Call an API

Lookup a value on a table: Template: {{ 'value' | dbLookup: 'table_name','field_name' }} Example: find the record has product code Z0001 { "product":{{ 'Z00001' | dbLookup: 'as_inventory','product_code' }}} Subtract a string from letter {{ 'string' | subtractRight: '-' }} {{ 'string' | subtractLeft: '-' }} Example: {{ '12345-12' | subtractRight: '-' }} >> result: 12345 {{ '12345-12' | subtractLeft: '-' }} >> result: 12 Call multiple APIs to get response for mapping "targetList": [ { "name":"prline", "method": "API", "api": { "url": "api url", "authenticationType": "Bearer", "token":"123", "method": "GET", "headers": { "Content-Type": "application/json", "tenantID": "657d0fa69ab9a5dba703f185" } } }   The data will be combined for mapping:{ "raw": from raw data, "prline": from response of api } Get a field has comma Template: jsonData['field_name']example: jsonData['@odata.context'] from json: {   "@odata.context":"value" }   jsonData['raw']['@odata.context'] from json:{ "raw": {   "@odata.context":"value" } } Loop the array in json {% for item in data.items %}     "itemName": "{{item.name}}" {% endfor %} If else condition {% if Vendor_Shipment_No != ''%}    "Document_Type": "Purchase Order", {% else %}    "Document_Type": "PO Creation", {% endif %} Validation and throw error message Use special field name: allsyncError {% if store_code==null or store_code==''%}     "allsyncError":"store_code is blank", {% endif %} Last record in loop {% for item in data.items %}     "itemName": "{{item.name}}" {% if forloop.last == false %},{% endif %} {% endfor %} {% endfor %}  Index in loop {% for item in data.items %}     "sequence": {{forloop.index}} {% endfor %}  Size of an array {% if value.size>0 %}        "Line_No":"{{value.first.Line_No}}" {% else %} Convert timestamp to date string "Posting_Date": "{{CREATED_DATE | date: "%Y-%m-%d"}}" Convert datetime string to timestamp: "order_date": {{created_at | date: '%s'}} Minus, multiply: "line_total": {{product.price | times: product.quantity | minus: product.total_discount}} Encryption {{ subject | sha256 }} : not able to decrypt {{ subject | aesEncode: 'key 32 character' }}  : method AES_GCM

Integration systems play a crucial role in modern businesses, enabling seamless communication and data flow between different applications, processes, and departments. Ignoring integration systems can have significant consequences for your business. Here are seven reasons why your business can't afford to ignore integration systems:   ### 1. **Enhanced Efficiency:** Integration systems automate repetitive tasks, reducing manual data entry and minimizing errors. This efficiency boost allows employees to focus on more strategic tasks, ultimately increasing productivity.   ### 2. **Improved Data Accuracy:** By integrating systems, you ensure that data is consistent across all platforms. This accuracy is vital for making informed decisions, enhancing customer service, and maintaining compliance with regulations.   ### 3. **Better Customer Experience:** Integration systems enable a 360-degree view of customer data. This comprehensive understanding of customer interactions and preferences allows businesses to provide personalized services, leading to improved customer satisfaction and loyalty.   ### 4. **Streamlined Communication:** Integration systems facilitate real-time communication between departments, suppliers, and partners. This streamlined communication ensures that everyone has access to the most up-to-date information, promoting collaboration and faster decision-making.   ### 5. **Cost Savings:** Automation and efficiency gains lead to cost savings in the long run. By eliminating manual processes and reducing errors, businesses save time and resources, which can be allocated to more strategic initiatives.   ### 6. **Adaptability and Scalability:** Integration systems are designed to be scalable and adaptable to changing business needs. As your business grows, these systems can easily accommodate new applications and technologies, ensuring that your operations remain efficient and effective.   ### 7. **Competitive Advantage:** In today's fast-paced business environment, staying ahead of the competition is essential. Businesses that embrace integration systems can respond more quickly to market changes, customer demands, and industry trends, giving them a significant competitive advantage.   In conclusion, integration systems are not just a luxury but a necessity for businesses looking to thrive in the digital age. Embracing these systems can lead to improved efficiency, cost savings, better customer experiences, and a strong competitive edge, making them indispensable for any forward-thinking organization.

Why is it important to enable 2FA? We highly recommend enabling two-factor authentication (2FA) for security reason: 2FA increases the security of your account. Even if somebody guesses your password, they won’t be able to access your account. App requirements Before enabling 2FA for your account on Allsync.io, you need to install authenticator app on your phone. Here are common authenticator apps can be found in your mobile device app store: Google Authenticator LastPass Authenticator Microsoft Authenticator Authy How do I enable 2FA? 1. Login to allsync.io, go to My account page 2. Enabling 2FA by click the checkbox 2FA 3. It will popup a screen with a QR code. Follow the steps provided in the screen to complete the setup 4. Open authenticator app, click + add new >> Scan the QR code at step 2 5. Enter the otp shown in authenticator app for step three 6. Test your 2FA setup After you've set up 2FA, try logging out then logging in from your current device or logging into your account from a different device to make sure everything is working correctly. If you encounter any issues, contact Allsync.io for assistance.   In conclusion, enabling 2FA is a simple and effective way to add an extra layer of security to your Allsync.io account. By following the steps above, you can help protect your personal and sensitive information from unauthorized access.

AllSync Connectors are running on cloud, however, there are many systems are required Local Network connection, example with SQL database, Oracle Database or SAP Hana Database.. which are not published through internet for allsync connection. There is an option for user to white list AllSync IPs, so only AllSync can connect, other network will not able to access. Another option, to deploy the connector on local server, so the integration will connect to local API, local database, and with AllSync and other 3rd party system. Contact AllSync to request for latest connector installer. 

Are you looking to streamline your business processes and improve efficiency? Look no further than iPaaS, or Integration Platform as a Service. This innovative technology is revolutionizing the way businesses connect their applications, data, and systems. But why should you consider implementing iPaaS for your organization? Seamless Integration iPaaS allows for seamless integration between different applications and systems, eliminating the need for manual data entry or complex coding. With iPaaS, you can easily connect your CRM, ERP, and other systems to ensure smooth data flow across your organization. Increased Efficiency By automating the integration process, iPaaS helps to increase efficiency and reduce the risk of errors. With real-time data synchronization, you can make informed decisions faster and stay ahead of the competition. Cost Savings Implementing iPaaS can lead to significant cost savings for your organization. By reducing the need for custom integration solutions and manual data entry, iPaaS helps to lower operational costs and improve overall ROI. Scalability As your business grows, so does the need for scalable integration solutions. iPaaS offers the flexibility to easily scale your integration processes as your business expands, ensuring that you can adapt to changing needs and requirements. Enhanced Security Security is a top priority for any organization when it comes to data integration. iPaaS provides built-in security features to protect your data and ensure compliance with industry regulations, giving you peace of mind that your information is safe and secure. With the numerous benefits that iPaaS offers, it's clear why more and more businesses are turning to this innovative technology to streamline their operations and drive growth. Consider implementing iPaaS for your organization and unlock the power of seamless integration today.