Scaffold WEB API

#1

Hi,
I am new to Quantify API, need some details like

  1. How do we access WEB API, what are the things required to access it?
  2. I am looking for Scaffold
  3. I downloaded the sample code of C# but getting an exception for DLL’s
    Avontus.Core
    Avontus.Rental.Library
    Avontus.Rental.Utility
    from where we can download this?

Need some sample for access Scaffold WEB API?

Regards
Pawan

#2

Hello!

In order to use the API, Quantify must be installed and you must be able to successfully connect to your datasource first. The installer will install these all necessary DLLs. A successful connection creates the appropriate connection settings in the C:\ProgramData\Avontus\Quantify\Settings\ folder.

-AvontusDev

#3

Thanks for information but still i am not able to connect to Database getting below error message. I am having SQLEXPRESS 2018. Using following credentials :

User Name : Admin
Password : password
Does it possible to have call so that we can discuss further?

“Avontus.Core.DataPortalException: DataPortal.Fetch failed (Login failed for user ‘ASIUser’.) —> Avontus.Core.Reflection.CallMethodException: DataPortal_Fetch method call failed —> System.Data.SqlClient.SqlException: Login failed for user ‘ASIUser’.
at System.Data.SqlClient.SqlInternalConnectionTds…ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource1 retry)
at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource1 retry) at System.Data.SqlClient.SqlConnection.Open() at Avontus.Core.Data.ConnectionManager1.GetManager(String database, Boolean isDatabaseName, String label)
at Avontus.Rental.Library.Database.DbVersion.DataPortal_Fetch(Criteria crit)
at dm(Object , Object[] )
at Avontus.Core.Reflection.MethodCaller.CallMethod(Object obj, DynamicMethodHandle methodHandle, Object[] parameters)
— End of inner exception stack trace —
at Avontus.Core.Reflection.MethodCaller.CallMethod(Object obj, DynamicMethodHandle methodHandle, Object[] parameters)
at Avontus.Core.Server.SimpleDataPortal.Fetch(Type objectType, Object criteria, DataPortalContext context)
— End of inner exception stack trace —
at Avontus.Core.DataPortal.Fetch(Type objectType, Object criteria)
at Avontus.Core.DataPortal.Fetch[T](Object criteria)
at Avontus.Rental.Library.Database.DbVersion.GetDBVersion()
at Avontus.Rental.Library.AvontusLogin.AttemptLogin(String userName, String password)
at ..(Object , EventArgs )”

#4

Hello. You don’t have your database installed correctly. ASIUser should be added if you follow the installation instructions here: https://docs.avontus.com/display/QUAN/Installing+Quantify